PDA

View Full Version : Problem with PostgresQL Service..



R Lazzaro
07-22-2011, 04:12 AM
I can't get the service to start.. it is stuck on Starting..


2011-07-21 16:43:32 PDT LOG: could not resolve "localhost": Unknown server error
2011-07-21 16:43:32 PDT LOG: disabling statistics collector for lack of working socket
2011-07-21 16:43:32 PDT WARNING: autovacuum not started because of misconfiguration
2011-07-21 16:43:32 PDT HINT: Enable the "track_counts" option.
2011-07-21 16:43:32 PDT LOG: database system was shut down at 2011-07-21 16:43:20 PDT
2011-07-21 16:43:36 PDT LOG: database system is ready to accept connections

This is the pg_log... please help.

netsrak
07-22-2011, 10:08 AM
Solutions:
1. Reboot your computer
2. If that doesn't help look for the hidden system file postmaster.pid in the postgresql data folder, delete it and reboot your computer again.
3. Check the postgresql service in the windows services (control panel->administration). Sometimes it helps to change the Logon As.. to "local system account"
4. Check our FAQ:
http://faq.holdemmanager.com/questions/91/Can%27t+Connect+%7B47%7D+Failed+to+Start+PostgreSQ L+

R Lazzaro
07-22-2011, 04:45 PM
I did all of those things, it still doesn't work. It says PostgresQL service started and then stopped.... I tried to change the logon as well. I have done everything in the FAQ, uninstalled all my anti virus software and disabled windows firewall.. cant figure this out


I forgot to mention that I am on Windows 7

Patvs
07-22-2011, 09:35 PM
turn on the secondary logon: The secondary logon service is a standard windows service which is available on every windows computer. In the latest versions it is not started automatically. You need to start it via control panel > administrative tools > services. Starting it once should insure it works in the future also.

Right-click run the HoldemManager installer -run as admin!-.

If it still won't install, run the manual 8.4.8 installer from PostgreSQL: The world's most advanced open source database (http://www.postgresql.org)