help!
I would just want to ask if what is the default password of postgresql after installing it... coz when i type su postgres it ask me a password which i dont know what?
Thnx
--
_______________________________________________
Sign-up for your own FREE Personalized E-mail at Email.com
http://www.email.com/?sr=signup
On Tue, 23 Apr 2002 03:05-0500, martin tan wrote:
I would just want to ask if what is the default password of
postgresql after installing it... coz when i type su postgres it
ask me a password which i dont know what?
Have you assigned a password at all to your postgres user?
This is done using the system password file.
PostgreSQL, I believe, does not store the password for the DBA
user.
If you have not assigned a password, you could su to root, then su to
postgres.
--
----------------------------------------------------------------------
Trond Endrest�l | trond@ramstind.gtf.ol.no
Patron of The Art of Computer Programming| FreeBSD 3.5-S & Pine 4.33
Well, you had to create that user, not postgresql! Log in as root and type:
passwd postgres
you can set the password to whatever you like.
Tim
----- Original Message -----
From: "martin tan" <martin_art_tan@email.com>
To: <pgsql-bugs@postgresql.org>
Sent: Tuesday, April 23, 2002 1:05 AM
Subject: [BUGS] help!
I would just want to ask if what is the default password of postgresql
after installing it... coz when i type su postgres it ask me a password
which i dont know what?
Show quoted text
Thnx
--_______________________________________________
Sign-up for your own FREE Personalized E-mail at Email.com
http://www.email.com/?sr=signup---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
martin tan writes:
I would just want to ask if what is the default password of
postgresql after installing it... coz when i type su postgres it
ask me a password which i dont know what?
I'm assuming you're on Linux, and i'm assuming you mean an RPM
installation, and i'm assuming you mean PostgreSQL 7.2.1,... and i'm
assuming you know this isn't a bug (replies to -general list)...
The documentation you installed has the answer, see:
/usr/share/doc/postgresql-7.2.1/README.rpm-dist
The user 'postgres' is created during installation of the server
subpackage. This user by default is UID and GID 26. The user has the
default shell set to bash, and the home directory set to
/var/lib/pgsql. This user also has no default password -- in order to
be able to su to from a non-root account or login as 'postgres' you
will need to set a password using passwd.
To summarise:
su -
passwd postgres
exit
Lee.