Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
default postgres user password on CentOS?
1 view
Skip to first unread message
Greg Russell
Nov 6, 2009, 12:37:48 PM11/6/09
to
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:
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?
Thomas Kellerer
Nov 6, 2009, 3:38:14 PM11/6/09
to
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-admin/2002-06/msg00197.php
http://www.depesz.com/index.php/2008/11/28/recovering-lost-postgresql-password/
Thomas
0 new messages