Postgres Pro
Downloads
Home   >   mailing lists

Thread: Password user postgres

Password user postgres

From
Arnaudo Massimo
Date:
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

Re: Password user postgres

From
"Tomasz Myrta"
Date:
> 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

Re: Password user postgres

From
Mathieu Arnold
Date:

--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

Re: Password user postgres

From
Oliver Elphick
Date:
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,
keepingwatch over their flock by night.     And, lo, the angel of the Lord came upon them, and the     glory of the
Lordshone around them; and they were      sore afraid. And the angel said unto them, " Fear not;     for behold I bring
yougood tidings of great joy which     shall be to all people. For unto you is born this day      in the city of David
aSaviour, which is Christ the      Lord."        Luke 2:8-11

Re: Password user postgres

From
Bhuvan A
Date:
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

Re: Password user postgres

From
Arnaudo Massimo
Date:
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

How can I use cursor in a trigger or function?

From
"dailiming"
Date:
Hi,everybody:     I design a database which is postgresql. I didn't success when I use cursor in function or trigger
justas in oracle. Did the postgresql support cursor in function?
 
Please help me.

Best wishes.                                     leon                                 dec,27/2002