Postgres Pro
Downloads
Home   >   mailing lists

Re: Password user postgres - Mailing list pgsql-sql

From Tomasz Myrta
Subject Re: Password user postgres
Date
Msg-id 20021222154829.M19941@klaster.net
Whole thread Raw
In response to Password user postgres  (Arnaudo Massimo <marnaudo@inwind.it>)
Responses Re: Password user postgres  (Arnaudo Massimo <marnaudo@inwind.it>)
List pgsql-sql
Tree view 
> 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?
> 
> Thanks
> Massimo

Change access from localhost 127.0.0.1 inside pg_hba.conf into  "trust" and 
restart postgres. After this you can login to postgres without any password 
and change forgotten password.
Tomasz Myrta

pgsql-sql by date:

Previous
From: Arnaudo Massimo
Date:
Subject: Password user postgres
Next
From: Mathieu Arnold
Date:
Subject: Re: Password user postgres