Lost password

Martin Roach <martin_roach2001@xxxxxxxxxxxx> · Mon, 15 Dec 2008 21:20:24 -0800 (PST)

Hi 

I started the installation of postrgres got distracted and then started again but forgot my password. I have received the info below:

Now what?
If you have access to shell account on the machine PostgreSQL is running, and your shell works as the same user as Postgres itself, or root - solution is easy.
Find your pg_hba.conf file. It might be in many files so try:

$ locate pg_hba.conf 
find /var/lib/ -type f -name pg_hba.conf 
find /etc -type f -name pg_hba.conf 
find / -type f -name pg_hba.conf 
Of course last option is your last resort - it will take a long time.

However, i'm not that computer savvy and don't now how to go about the above. How come you can't just delete the software and try again?

Any help in finding these files and working what to do would be a massive help.

Thanks.

Start your day with Yahoo!7 and win a Sony Bravia TV. Enter now.