Skip site navigation (1) Skip section navigation (2)

Re: What is postgres password.

From: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
To: HK <harikrishnan(at)midascomm(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: What is postgres password.
Date: 2002-10-18 11:11:39
Message-ID: 1034939499.22825.229.camel@linda (view raw, whole thread or download thread mbox)
Lists: 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

  # 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 HatcherDate: 2002-10-18 12:42:42
Subject: Vacuum question
Previous:From: HKDate: 2002-10-18 09:03:28
Subject: What is postgres password.

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group