![]() 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 20 below. The postgres program also takes a number of other command-line options. (See Section 25.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. $ postgres -D /usr/local/pgsql/data >logfile 2>&1 & For this, use the usual Unix shell syntax: 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. The bare-bones way to start the server manually is just to invoke postgres directly, specifying the location of the data directory with the -D option, for example: Consult the package-level documentation for details. Using the package's infrastructure to start the server will be much less work than figuring out how to do this yourself. If you are using a pre-packaged version of PostgreSQL, it almost certainly includes provisions for running the server as a background task according to the conventions of your operating system. The database server program is called postgres. ![]() Client Connection Problemsīefore anyone can access the database, you must start the database server.
0 Comments
Leave a Reply. |