Re: Password recover - Mailing list pgsql-admin

From Aaron Spiteri
Subject Re: Password recover
Date
Msg-id 20020624.22324700@scooby.m1group.com.au
Whole thread Raw
In response to Password recover  ("Peter Arzamendi" <arzamendi@berbee.com>)
List pgsql-admin

I had the same problem a while a go the way I fixed was like this:

  1. Log in has root user on the server.

  2. Swith to postgres user "su postgres"

  3. Make a back up of your pg_hda.conf file. On RH this is in /var/lib/pgsql/data

  4. Alter the pg_hda.conf to trust all types of conections and restart the postmaster. Something like "/etc/init.d/postgres restart"

  5. Log into PG using "pgsql template1" then change the sa password using "ALTER USER sa WITH PASSWORD 'password';

  6. You can also check what the password is depending on how the pg_hda.conf file was setup by using the following syntax in pgsql. "SELECT * FROM pg_shadow WHERE usename='sa';

  7. Note that on PG < version 7 the syntax is slightly different you do not put the "'" around the password.

  8. Copy the backup of the pg_hda.conf file on top of the altered pg_hda.conf file and restart the postmaster.

  9. Check that your security is back to normal.

Hope this helps.

Aaron@m1group.com.au




Original Message dated 23/06/02, 13:03:34

Author: "Peter Arzamendi" <arzamendi@berbee.com>

Re: [ADMIN] Password recover:




Is there a way to recover the sa password?

Thanks,
Pete

pgsql-admin by date:

Previous
From: Larry Rosenman
Date:
Subject: Re: Password recover
Next
From: Tom Lane
Date:
Subject: Re: Slow Remote connection