Re: Lost password

It is assumed you are running Unix (or Linux). The commands you've
been provided with are standard Unix system commands that will help
you find the files (pg_hba.conf) you are looking for, the output of
these commands (locate or find) is the absolute path to your queried
file (in your case pg_hba.conf) if found. Once you find the file you
will then need to edit this file, this file may only be accessible by
user root or user postgres (I could be wrong). Once edited you may
want to restart PostgreSQL then try to log in. For help on how to edit
the pg_hba.conf file (and to understand what each section if it's
contents means) you will need to look at the PostgreSQL documentation.

If you still have difficulties you may what to Google for more
elaborate answers or use the man command.

Allan.

On Tue, Dec 16, 2008 at 7:20 AM, Martin Roach
<martin_roach2001(at)yahoo(dot)com(dot)au> wrote:
> 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.