===== PostgreSQL =====

==== PostgreSQL database initialization ====

Create a user for example : postgres

Connect to your system a this user (su - postgres)

<cli prompt='#'>
root# mkdir /usr/local/pgsql/data
root# chown postgres /usr/local/pgsql/data
root# su postgres
postgres$ initdb -D /usr/local/pgsql/data
</cli>

Alternatively, you can run initdb via the pg_ctl program like so:
<cli prompt='#'>
$ pg_ctl -D /usr/local/pgsql/data initdb
</cli>

**Tip:** As an alternative to the -D option, you can set the environment variable PGDATA.