Initializing the Data Directory in PostgreSQL
Installation initializes the database and sets the permissions on the data directory to their correct values.
Caution
The initdb
program sets the permissions on the data directory to 700
. You should not change these permissions to anything else to avoid creating a security hole.
You can start the postmaster
program with the following command (make sure you are still the user postgres
):
matthew@seymour:~$ postmaster -D /usr/local/pgsql/data &
If you have decided to use a directory other than /usr/local/pgsql/data
as the data directory, you should replace the directory in the postmaster command line with whatever directory you are using.
Tip
By default, Ubuntu makes the PostgreSQL data directory ...
Get Ubuntu Unleashed 2013 Edition: Covering 12.10 and 13.04, Eighth Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.