Many systems have a file /etc/rc.local or /etc/rc.d/rc.local. Installing one will require root privileges.ĭifferent systems have different conventions for starting up daemons at boot time. There are a few distributed with PostgreSQL in the contrib/start-scripts directory. Autostart scripts are operating-system-specific. Normally, you will want to start the database server when the computer boots. pg_ctl is also capable of stopping the server. The -D option has the same meaning here as for postgres. Will start the server in the background and put the output into the named log file. ![]() Therefore the wrapper program pg_ctl is provided to simplify some tasks. This shell syntax can get tedious quickly. For more information, see the postgres reference page and Chapter 18 below. The postgres program also takes a number of other command-line options. (See Section 23.3 for a more thorough discussion of log file handling.) It will help for auditing purposes and to diagnose problems. It is important to store the server's stdout and stderr output somewhere, as shown above. For this, use the usual Unix shell syntax: $ postgres -D /usr/local/pgsql/data >logfile 2>&1 & Normally it is better to start postgres in the background. If that variable is not provided either, it will fail. Without -D, the server will try to use the data directory named by the environment variable PGDATA. This must be done while logged into the PostgreSQL user account. Which will leave the server running in the foreground. Thus, the simplest way to start the server is: $ postgres -D /usr/local/pgsql/data ![]() The postgres program must know where to find the data it is supposed to use. The database server program is called postgres. Before anyone can access the database, you must start the database server.
0 Comments
Leave a Reply. |