pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: Password user postgres
6+ messages / 5 participants
[nested] [flat]
* Re: Password user postgres
@ 2002-12-22 07:48 Tomasz Myrta <jasiek@klaster.net>
parent: Arnaudo Massimo <marnaudo@inwind.it>
3 siblings, 1 reply; 6+ messages in thread
From: Tomasz Myrta @ 2002-12-22 07:48 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Password user postgres
@ 2002-12-22 15:09 Mathieu Arnold <mat@mat.cc>
parent: Arnaudo Massimo <marnaudo@inwind.it>
3 siblings, 0 replies; 6+ messages in thread
From: Mathieu Arnold @ 2002-12-22 15:09 UTC (permalink / raw)
To: marnaudo@inwind.it; +Cc: pgsql-sql
--En cette belle journée de lundi 23 décembre 2002 15:22 +0100,
-- Arnaudo Massimo écrivait avec ses petits doigts :
> 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?
I believe that on my 7.2 :
cat /usr/local/pgsql/data/global/pg_pwd
will tell you everything, the first field being the login and the seventh
being the password.
--
Mathieu Arnold
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Password user postgres
@ 2002-12-22 23:27 Oliver Elphick <olly@lfix.co.uk>
parent: Arnaudo Massimo <marnaudo@inwind.it>
3 siblings, 0 replies; 6+ messages in thread
From: Oliver Elphick @ 2002-12-22 23:27 UTC (permalink / raw)
To: marnaudo@inwind.it; +Cc: pgsql-sql
On Mon, 2002-12-23 at 14:22, 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.
The Debian packages do not set any password.
Their default access is "ident sameuser", meaning that you can connect
using your Unix login name, provided that user has also been created as
a PostgreSQL user. The PostgreSQL superuser is 'postgres'.
--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"And there were in the same country shepherds abiding
in the field, keeping watch over their flock by night.
And, lo, the angel of the Lord came upon them, and the
glory of the Lord shone around them; and they were
sore afraid. And the angel said unto them, " Fear not;
for behold I bring you good tidings of great joy which
shall be to all people. For unto you is born this day
in the city of David a Saviour, which is Christ the
Lord." Luke 2:8-11
^ permalink raw reply [nested|flat] 6+ messages in thread
* Password user postgres
@ 2002-12-23 14:22 Arnaudo Massimo <marnaudo@inwind.it>
0 siblings, 4 replies; 6+ messages in thread
From: Arnaudo Massimo @ 2002-12-23 14:22 UTC (permalink / raw)
To: 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
--
E impari che puoi davvero sopportare,
che sei davvero forte,
e che vali davvero.
--- ---
HomePage: http://spazioinwind.iol.it/arnaudo
LinuxGroup: http://www.lugge.net
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Password user postgres
@ 2002-12-25 09:03 Bhuvan A <bhuvansql@myrealbox.com>
parent: Arnaudo Massimo <marnaudo@inwind.it>
3 siblings, 0 replies; 6+ messages in thread
From: Bhuvan A @ 2002-12-25 09:03 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Password user postgres
@ 2002-12-25 19:05 Arnaudo Massimo <marnaudo@inwind.it>
parent: Tomasz Myrta <jasiek@klaster.net>
0 siblings, 0 replies; 6+ messages in thread
From: Arnaudo Massimo @ 2002-12-25 19:05 UTC (permalink / raw)
To: pgsql-sql
Hi everibody,
thanks for the answers: i have resolved.
Massimo
--
E impari che puoi davvero sopportare,
che sei davvero forte,
e che vali davvero.
--- ---
HomePage: http://spazioinwind.iol.it/arnaudo
LinuxGroup: http://www.lugge.net
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2002-12-25 19:05 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-12-23 14:22 Password user postgres Arnaudo Massimo <marnaudo@inwind.it>
2002-12-22 07:48 ` Tomasz Myrta <jasiek@klaster.net>
2002-12-25 19:05 ` Arnaudo Massimo <marnaudo@inwind.it>
2002-12-22 15:09 ` Mathieu Arnold <mat@mat.cc>
2002-12-22 23:27 ` Oliver Elphick <olly@lfix.co.uk>
2002-12-25 09:03 ` Bhuvan A <bhuvansql@myrealbox.com>
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