Re: What is postgres password. - Mailing list pgsql-novice

From Oliver Elphick
Subject Re: What is postgres password.
Date
Msg-id 1034939499.22825.229.camel@linda
Whole thread Raw
In response to What is postgres password.  (HK <harikrishnan@midascomm.com>)
List pgsql-novice
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
yourself:

  # 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.Elphick@lfix.co.uk
Isle of Wight, UK
http://www.lfix.co.uk/oliver
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


pgsql-novice by date:

Previous
From: HK
Date:
Subject: What is postgres password.
Next
From: Bruno Wolff III
Date:
Subject: Re: char() or varchar() for frequently used column