next up previous contents
Next: Setting pg_hba.conf Up: Macintosh and Linux Previous: Installing pgcrypto   Contents

Setting the postgres password

Just after installation, you can access the database "postgres" without authentication as the user postgres by running the PostgreSQL interactive terminal program, called psql.

$ /usr/local/pgsql/bin/psql

When you are prompted, type as follows.

postgres=# alter role postgres with password 'your_password';
(your_password should be read as a new password you want to set.)



manabu 2010-11-14