|
|
default postgres user password on CentOS?
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?
|
|
0
|
|
|
|
Reply
|
 Greg
|
11/6/2009 5:37:48 PM |
|
Greg Russell wrote on 06.11.2009 18:37:
> 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?
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
|
|
|
|
Reply
|
Thomas
|
11/6/2009 8:38:14 PM
|
|
|
1 Replies
3342 Views
(page loaded in 7.383 seconds)
Similiar Articles: Mrtg indexmaker doesnt wanna initiliaze - comp.dcom.net-management ...default postgres user password on CentOS? - comp.databases ... Mrtg indexmaker doesnt wanna initiliaze - comp.dcom.net-management ... > I >see on default is locahost and ... PSP8 No Default Printer Installed - comp.graphics.apps.paint-shop ...default postgres user password on CentOS? - comp.databases ... Hello, I'm new to postgresql and have installed it on CentOS 5.3 via yum. ... PRINTER - comp.protocols.snmp ... Old root password - comp.sys.hp.hpuxI've lost root password, but a have access to system from another user who id = 0 . ... Old root password - comp.sys.hp.hpux Password Security and /etc/default ... Please help: Latest Sunfire v20Z bios, etc. - comp.unix.solaris ...default postgres user password on CentOS? - comp.databases ... Please help: Latest Sunfire v20Z bios, etc. - comp.unix.solaris ..... article on Larry Ellison and company's ... Help on resetting root password in Cyclade for Solaris servers ...In order to reset it to the original factory default password of "tslinux". ... CentOS Enterprise Linux Step by Step Guide - Forgotten root Password Linux for ... Table with 400000 rows takes a long time to count - comp.databases ...MySQL is of version 5.0.22 on a CentOS system. I thought that MySQL, at ... mysqld] datadir=/var/lib/mysql #socket=/var/lib/mysql/mysql.sock # Default to using old password ... Can a procedure contain only a SELECT statement? - comp.databases ...... expecting one of the > following: =A0:=3D), default ... do this: mgogala@nycwxp2622:~$ PGHOST=lpo-postgres-01 mgogala@nycwxp2622:~$ psql -U scott Password for user ... Damn Technology: Django with PostgreSQL on CentOS/RHEL 5Yes, the default PostgreS QL user is ... line, change the PostgreS QL user postgres ‘s password: ... to use Nginx, CentOs or RedHat, Django 1.1.1 and Postgres ... what is the default username password for PostgreSQL, which was ...what is the default username password for PostgreSQL, which was installed with FC5. 7/23/2012 1:48:48 PM
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
0 followers. 