Page 1 of 2

POSTgres problem

PostPosted: Tue Feb 27, 2018 10:03 pm
by 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

Re: POSTgres problem

PostPosted: Wed Feb 28, 2018 7:03 am
by Flag_Hippo
What is the problem and how do you solve it? What PostgreSQL version are you using?

Re: POSTgres problem

PostPosted: Wed Feb 28, 2018 1:22 pm
by 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)

Re: POSTgres problem

PostPosted: Wed Feb 28, 2018 3:24 pm
by Flag_Hippo
Why are you deleting the 'postgres' user after using CCleaner?

Re: POSTgres problem

PostPosted: Sun Mar 04, 2018 6:13 pm
by benjamin.chalot
Hi

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

pt4 error message.png

Re: POSTgres problem

PostPosted: Mon Mar 05, 2018 6:49 am
by 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.

Re: POSTgres problem

PostPosted: Mon Mar 05, 2018 7:12 am
by benjamin.chalot
Hi Hippo

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

postmaster pid file.png

Re: POSTgres problem

PostPosted: Mon Mar 05, 2018 11:24 am
by 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'?

Re: POSTgres problem

PostPosted: Mon Mar 05, 2018 12:15 pm
by 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.

Re: POSTgres problem

PostPosted: Mon Mar 05, 2018 1:54 pm
by benjamin.chalot
Is it possible that we dont have the latest version 9.3 of pql ?