Quick Links

Re: Password user postgres

From:	"Tomasz Myrta" <jasiek(at)klaster(dot)net>
To:	marnaudo(at)inwind(dot)it, PosgreSQL Mailing List <pgsql-sql(at)postgresql(dot)org>
Subject:	Re: Password user postgres
Date:	2002-12-22 07:48:29
Message-ID:	20021222154829.M19941@klaster.net
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-sql

> 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

In response to

Password user postgres at 2002-12-23 14:22:38 from Arnaudo Massimo

Responses

Re: Password user postgres at 2002-12-25 19:05:59 from Arnaudo Massimo

Browse pgsql-sql by date

	From	Date	Subject
Next Message	Philip Warner	2002-12-22 10:18:22	Re: create index on function - why?
Previous Message	Terry Yapt	2002-12-21 19:12:50	Parameterized Views on 7.3