On Fri, 2002-10-18 at 10:03, HK wrote:
> hi all,
> can anybody tell me the password of postgres user in RH linux
> 7.2. The pgsql i am using comes as part of the RH linux 7.2.
> Right now i am logging as root and using su - postgres to use postgrey.
> thanx in advance.
It ought (I am not a RH user) to be an account which by default cannot
be used directly - i.e. the password field in /etc/shadow should contain
"*" which cannot be matched by anything. It would be very bad practice
for RH to set a default password for any user.
If you want to be able to log in directly, set a password for it
# passwd postgres
but in my opinion the way you are doing it now is preferable - if
someone were to log in directly as 'postgres', how could you know which
particular individual had logged in?
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight, UK
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
"Delight thyself also in the LORD; and he shall give
thee the desires of thine heart." Psalms 37:4
In response to
pgsql-novice by date
|Next:||From: Patrick Hatcher||Date: 2002-10-18 12:42:42|
|Subject: Vacuum question|
|Previous:||From: HK||Date: 2002-10-18 09:03:28|
|Subject: What is postgres password.|