Postgres Pro
Downloads
Home   >   mailing lists

Re: Password user postgres - Mailing list pgsql-sql

From Bhuvan A
Subject Re: Password user postgres
Date
Msg-id Pine.LNX.4.44.0212251430360.9666-100000@Bhuvan.bksys.co.in
Whole thread Raw
In response to Password user postgres  (Arnaudo Massimo <marnaudo@inwind.it>)
List pgsql-sql
Tree view 
On Mon, 23 Dec 2002, Arnaudo Massimo wrote:

> Hi everibody,
> i have to see the table pg_shadow, but i don't remind the default password
> for user postgres in a Debian system.
> 
> Can you help me?

Edit pg_hba.conf and set the method to 'trust' and restart postmaster.  
Login(it wont ask for password) and change the password of postgres user,
restore pg_hba.conf and restart postmaster.

regards,
bhuvaneswaran

pgsql-sql by date:

Previous
From: "Nikola Ivacic"
Date:
Subject: Re: COPY command problems
Next
From: Arnaudo Massimo
Date:
Subject: Re: Password user postgres