Had to uninstall postgresql

[snoopy]

Hello,

got an error message about postgresql, something about not connectiong to local host, you know the one. Anyway tried rebooting, tried running postgresql from start bar etc - nothing. So I uninstalled PT3 and postgresql (not deleting my database), downloaded the newest version of PT3 and then attempted to install.

Problem is, I need the password to get into my postgresql database and I can't remember it since I haven't needed to enter it since the 3 weeks ago when i first set it up. Can it be recovered? I also tried to set up an alternative database but it doesn't seem to let me.

Help?

Worst case I can just delete the whole database, start a new one, request hand histories from poker stars and import them in, right?

Thanks

[WhiteRider]

Problem is, I need the password to get into my postgresql database and I can't remember it since I haven't needed to enter it since the 3 weeks ago when i first set it up. Can it be recovered? I also tried to set up an alternative database but it doesn't seem to let me.

Default password is dbpass, but if that doesn't work, you can remove the need for passwords:
How To: Remove PostgreSQL Password

Worst case I can just delete the whole database, start a new one, request hand histories from poker stars and import them in, right?

Correct, but the hand history files are probably still on your computer in the "move processed files to" folder - see the auto import tab to see where this folder is.

[snoopy]

Hello, thanks for swift response but sadly that has not helped. In that link you gave me I followed the instructions, changed the word to "trust" but when I do: "Start -> Programs -> PostgreSQL -> Reload Configurations" as the final step I get an error message saying "This application has failed to start because libpq.dll was not found. Re-installing the application may fix this problem"

Please advise me on what to do to rectify this.

[WhiteRider]

Sorry, I don't know enough about postgres to answer that, but I'm sure one of the postgres experts will let you know..
What version of postgres do you have?

[Peligroso]

Try the following:

Download http://support.nusphere.com/sshot/libpq20080512.zip, unzip it and place it in your PostgreSQL\Bin directory.

[snoopy]

Peligroso I tried that but when I try to reload configuration it gives the same error message. To clarify exactly what I am doing, I have untinstalled PT3 and the version of Postgres that came with it and downloaded the latest version of PT3 which comes bundled with Postgres. The password dialogue box appears when I am installing Postgres, so Postgres isn't fully installed yet because it won't let me complete the installation process without the password.

I have tried to disable the need for a password by following the advice in this thread but nothing has worked. In particular when I set the password feature to "trust" and try to reload the configuration I get an error message, thus preventing me from bypassing the password dialogue box in the installation of postgres.

That's just to clarify/summarise the exact problem I have.

Any alternatives?

Thanks.

Sorry, I don't know enough about postgres to answer that, but I'm sure one of the postgres experts will let you know..
What version of postgres do you have?

8.2

[WhiteRider]

Ah, if you uninstalled postgres, please make sure you FULLY uninstalled it:
this topic

[Peligroso]

It sounds weird. If it doesn't feel like too much hassles, I'd like you to try to uninstall and reinstall once again.

Go to Control Panel -> Add/Remove Programs and uninstall PostgreSQL.

Now, to completely remove the traces of PostgreSQL; go Start -> Run and write "cmd" to start the command prompt. In the command prompt, write "net user postgres /delete" (without the quotation marks). Also, go to C:\Program Files and make sure that your PostgreSQL folder is deleted.

Now, download PostgreSQL 8.3.3 from here:
ftp://ftp.postgresql.org/pub/binary/v8. ... .3.3-1.zip
Or if you're using Windows Vista, download PostgreSQL 8.2.7 here:
ftp://ftp.postgresql.org/pub/binary/v8. ... .2.7-1.zip

Run the installation file and install PostgreSQL.

[keggler]

so you now have a copy of libpq.dll in your postgres bin folder?

if so, try adding that folder to your path.


susan

[keggler]

or, set up a 1 line .bat file to launch pt3 and save it in the bin folder and launch pt3 from this file.

susan