Re: Lost password

That is a windows user account problem, you will need to have Windows
administrative privileges to reset the password for user postgres.

Allan.

On Wed, Dec 17, 2008 at 5:15 PM, Martin Roach
<martin_roach2001@yahoo.com.au> wrote:
> 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.