pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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> (raw)
In-Reply-To: <20021223142238.GA4387@gull.zena.it>
References: <20021223142238.GA4387@gull.zena.it>

> 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



view thread (6+ messages)  latest in thread

Message-ID: <20021222154829.M19941@klaster.net>
Permalink:  ../20021222154829.M19941@klaster.net/
Also on:    postgresql.org/message-id/20021222154829.M19941@klaster.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: jasiek@klaster.net
  Subject: Re: Password user postgres
  In-Reply-To: <20021222154829.M19941@klaster.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox