Re: Password user postgres

From: Bhuvan A <bhuvansql(at)myrealbox(dot)com>
To: PosgreSQL Mailing List <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Password user postgres
Date: 2002-12-25 09:03:09
Message-ID: Pine.LNX.4.44.0212251430360.9666-100000@Bhuvan.bksys.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Arnaudo Massimo 2002-12-25 19:05:59 Re: Password user postgres
Previous Message Nikola Ivacic 2002-12-24 15:55:05 Re: COPY command problems