frustrated with the FAQ's

[leoslayer]

my god sometimes you computer guys are too smart to talk to us regular people. please for the love of god put pictures with the directions so we dont screw things up.

To edit the pg_hba.conf file, do the following:

1. Go to C:\Program Files\PostgreSQL\8.x\data, move the pg_hba file to your Desktop and open it with notepad.
2. Scroll to the bottom and change all md5 references to trust. Save and close the file.
3. Move the file back to the data folder.
4. Restart the PostgreSQL service: Control Panel → Administrative Tools → Services
where do i write trust? do i erase where it says md5 and write trust or dose it go somewhere else on the line?

[Patvs]

Try to:

click on Start and go to Programs -> Accessories -> Command Prompt

* If you are on Vista, rightclick and choose "Run as Administrator".


A black box should appear. Type 'net user postgres /delete' (without the quotes) and press enter.

The user is now deleted and you can (re)install PostgreSQL. And it should accept ANY password.



----

This is somewhat easier than editing the pg_hba.conf file.
Or can just delete md5 and replace it with trust.

[leoslayer]

it did not work the pasword should be postgrespass but it keeps saying its incorrect and it wont let me go forward with the install. all because i got this cant connect to 1.207 thing all of a sudden. so i am trying to reinstall and it wont let me.
i fell like throwing the damn thing out the window.

[Patvs]

Delete the postgres user first (what I posted above)... then it should accept ANY password

[leoslayer]

ok this is what i did your steps then enter then it dropped down a couple of lines and had a cursor but the other stuff was gone. so i figured that was correct then tried installing again from the download i had saved. should i have re downloaded?

[leoslayer]

http://img824.imageshack.us/img824/9885/postgress.th.png (http://img824.imageshack.us/i/postgress.png/)

Uploaded with ImageShack.us (http://imageshack.us)

[leoslayer]

http://img259.imageshack.us/img259/4844/postgress2.th.png (http://img259.imageshack.us/i/postgress2.png/)

Uploaded with ImageShack.us (http://imageshack.us)

now i assume i do not type anything else next to the prompt where it is blank close the command promt then i can enter any pass in the box above or do i need to abort install and reopen the download or do i have to re download 8.4?

[netsrak]

You are not entering the command in the correct syntax - there is no space between the / and the word delete

net"space"user"space"postgres"space"/"nospace"delete

[leoslayer]

well i got it to work but postgress did not give me a chance to save my old database so i lost a lot of info.

thanks for your help at least i have something now