Reinstalling PostgreSQL

[WhiteRider]

You will need to stop the postgres service before you try to update it. HAve you done that?
Beyond that, I'm not sure what the problem would be, but I'll try to get someone to look at this thread.

[APerfect10]

There are two user accounts for PostgreSQL which have passwords. The database user and the service account. Adding "trust" in your pg_hba.conf file is only for the database user account. The PostgreSQL service account is entirely different. If you installed PostgreSQL using PokerTracker 3 then the default username/password are "postgres/svcpass".

If they are not the correct password and you do not remember the password that you created then you will need to delete the postgres service account by going to your Windows command prompt (Start -> Run, 'cmd') and typing:

Code: Select all

net user postgres /delete

Once you delete the service account, you should be able to recreate it during the upgrade process.

Best regards,

Derek

[DerekG]

Thanks Derek.

I tried svcpass (both caps on and off) and it told me the pw was incorrect so I will probably need to delete it as you say. It appears to attempt to set up port 5432 by default when installing. Do I need to change this to 5434 and give my old dbname/dbpass in order to access my already existing databases?

Tried doing a system restore once I found out I couldn't install PSQL. Of course that didn't work. Windows FTL.

[kraada]

When you reinstall, just make sure to have the "Initialize Database Cluster" checkbox unchecked. If you check that box it will destroy your data.

It doesn't matter what port you have it on or what username you use so long as the data is there.