POSTgres problem

[bibibiatch]

Hello i aquired PT4 6 months ago and every month i have a postgres SQL problem that i solve but still how can i get rid of it forever
thanks for your help guys

[Flag_Hippo]

What is the problem and how do you solve it? What PostgreSQL version are you using?

[bibibiatch]

apres avoir run Ccleaner redemarrer lordi
ouvrir CMD run as admin
net user postgres /del

redemarrer lordi

net user postgres postgrespass /add
enter apres chaque commance
net localgroup Administrators postgres /add
net localgroup Users postgres /delete
runas /user:postgres cmd.exe

apres cette commande taper le code "postgrespass" (mm si rien ne saffiche)

cd c:\
enter
start postgresql-8.4.22-1-windows.exe
enter

i did all this (sorry some words are in french)

[Flag_Hippo]

Why are you deleting the 'postgres' user after using CCleaner?

[benjamin.chalot]

Hi

I am a friend of bibibiatch. I have the exact same problem.
Here is the first error message :

[Flag_Hippo]

Locate and delete the postmaster.pid file if it is present (not "postmaster.opts" which may be there too). You can find that file in C:\Program Files\PostgreSQL\9.3\data\ although you may have a different PostgreSQL version (e.g. 8.4, 9.0) or have it installed in C:\Program Files (x86). Once it's deleted, reboot and try starting PokerTracker 4 again.

[benjamin.chalot]

Hi Hippo

Thanks for the reply.
I cant locate that postmaster.pid file

[Flag_Hippo]

Can you please try and keep everything in a single thread as you are regularly reporting this issue and in this thread I asked if you had more than one PostgreSQL version installed and you said you had v.8.4 (as per your screenshot here):

C:\Program Files (x86)\PostgreSQL\8.4\data\

However in this thread you included a screenshot showing that you had a PostgreSQL here:

C:\postgreSQL\data

Is there a postmaster.pid file in that directory? If you open the 'PG_VERSION' file with notepad what version does it say this is? Do you see more than one PostgreSQL in 'Control Panel -> Programs & Features'?

[benjamin.chalot]

My bad. Lets keep everything here.
I have only one psq installed on the computer (as far as I know...) The PG_version file says 8.4 and there is only one PSQL in the Program section of Control Panel.

[benjamin.chalot]

Is it possible that we dont have the latest version 9.3 of pql ?