Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 0F22A4760E8
	for <pgsql-sql@postgresql.org>; Sun, 22 Dec 2002 09:50:28 -0500 (EST)
Received: from serwer.skawsoft.com.pl (serwer.skawsoft.com.pl [213.25.37.66])
	by postgresql.org (Postfix) with ESMTP id 0F7AD475C14
	for <pgsql-sql@postgresql.org>; Sun, 22 Dec 2002 09:50:26 -0500 (EST)
Received: from lamer.pl (localhost [127.0.0.1])
	by serwer.skawsoft.com.pl (Postfix) with ESMTP
	id 156B22B85E; Sun, 22 Dec 2002 15:48:29 +0100 (CET)
From: "Tomasz Myrta" <jasiek@klaster.net>
To: marnaudo@inwind.it,
	PosgreSQL Mailing List <pgsql-sql@postgresql.org>
Subject: Re: Password user postgres
Date: Sun, 22 Dec 2002 15:48:29 +0800
Message-Id: <20021222154829.M19941@klaster.net>
In-Reply-To: <20021223142238.GA4387@gull.zena.it>
References: <20021223142238.GA4387@gull.zena.it>
X-Mailer: Open WebMail 1.62 20020221
X-OriginatingIP: 217.96.97.138 (jasiek)
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-2
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200212/257
X-Sequence-Number: 10845

> 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