Tip: If you did not grant your new user database creation privileges, add -U postgres to the previous command. If these are the kind of lines you see, then the process succeeded. Pg_ctl -D /var/lib/postgres/data -l logfile start You can now start the database server using: auth-local and -auth-host, the next time you run initdb. You can change this by editing pg_hba.conf or using the option -A, or WARNING: enabling 'trust' authentication for local connections Performing post-bootstrap initialization. Selecting dynamic shared memory implementation. The default text search configuration will be set to 'english'.įixing permissions on existing directory /var/lib/postgres/data. The default database encoding has accordingly been set to 'UTF8'. The database cluster will be initialized with locale 'en_US.UTF-8'.

This user must also own the server process. The files belonging to this database system will be owned by user 'postgres'. Many lines should now appear on the screen with several ending by. $ initdb -locale=en_US.UTF-8 -E UTF8 -D /var/lib/postgres/data

-E encoding for the encoding (which must match the chosen locale).-locale= locale, where locale is to be chosen amongst the system's available locales.However, depending on your settings and use cases this might not be what you want, and you can override the defaults using: Note that by default, the locale and the encoding for the database cluster are derived from your current environment (using $LANG value). Where -D is the default location where the database cluster must be stored (see #Change default data directory if you want to use a different one). Initial configurationīefore PostgreSQL can function correctly, the database cluster must be initialized: Note: Commands that should be run as the postgres user are prefixed by $ in this article.

Gui for postgres