Lost password

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.

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.

Hi
�
I started the installation of postrgres got distracted and then started again but forgot my password

Hi Allan

Hi Allan

I have deleted the Postgres files so I can re-install. Originally I don't
know if I fully installed the program - I don't think I did. What I did
however is log in a password that won't go away even If I delete the
software. Now if I delete the software and re-install it still asks for
this password. I had a computer savvy friend come over and help but to no
avail. If I try and install it now and I provide a password it gives the
following message "the password specified was incorrect. Please enter the
correct password for the postgres windows user account". I believe somewhere
this password has been registered and won't go away even if the software is
deleted.

Any help much appreciated!

PS I use windows vista and my friend turned my user account control off.

Why on earth is there not a retrieve password function - unbelievable.

Marty.

--- On Tue, 16/12/08, Allan Kamau <kamauallan@gmail.com> wrote:

From: Allan Kamau <kamauallan@gmail.com>
Subject: Re: [GENERAL] Lost password
To: martin_roach2001@yahoo.com.au
Cc: pgsql-general@postgresql.org
Received: Tuesday, 16 December, 2008, 7:32 PM

-----Inline Attachment Follows-----

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@yahoo.com.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.

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