Hello, I'm new to postgresql and have installed it on CentOS 5.3 via yum. I
am attempting to install an application that uses postgresql as its
database, and am running application-supplied scripts to create the ah3 user
and database structure, e.g:

su -c "createuser -h localhost --createdb --no-createrole --no-superuser
ah3" postgres

su -c "createdb -h localhost --owner ah3 ah3" postgres

su -c "psql -h localhost --user ah3 ah3 < /opt/ah3/database/ah3.psql"
postgres

I don't know what is the default password is for the user "postgres"
however. How do I fix this problem, please?

Greg Russell wrote on 06.11.2009 18:37:
I don't know about CentOS but normally the password for the postgres DB user is supplied during installation.

However, you can easily reset the password:

http://archives.postgresql.org/pgsql...6/msg00197.php
http://www.depesz.com/index.php/2008...esql-password/

Thomas