PDA

View Full Version : Postgres sql won't start 64 bit vista



Antix
11-05-2009, 10:25 PM
It used to start, but now the service won't start at all. I have tried uninstalling any anti virus and all that. The event viewer says issues iwth the postmaster.pid.

Need help please.

fozzy71
11-05-2009, 11:45 PM
This is usually a firewall or windows update issue.

First try to delete the \postgresql\8.x\data\postmaster.pid file, if you see it, and reboot.

If no help, try this:

Start > Programs > PostgreSQL > 8.x > Stop Service

Start > Programs > PostgreSQL > 8.x > Start Service

Add exceptions to the windows firewall, even if it is off. If you have a 3rd party firewall, do the equivalent or uninstall it temporarily - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=171

Please try following all of these FAQs, step by step:

1) http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=34
2) reinstall the same version of postgresql, using the same \data folder - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=177
3) http://www.holdemmanager.net/forum/showthread.php?t=8261

If that doesn't help you will probably have to reinstall PostgreSQL completely and reimport your hands.

Antix
11-06-2009, 01:43 PM
Ok, I uninstalled and am trying to install the latest version of 8.3 and I am getting an error saying 64-bit integers and free floating integers incompatibility......

I am looking to wipe my OS and put linux with a XP VM. Is there a way to get a backup of the db without reinstalling postgres?

fozzy71
11-06-2009, 03:55 PM
The easiest way, if you have an external hard drive, is to copy the entire \postgresql\8.3\data folder. Then you can reinstall the same version of postgresql on the new OS and point the data directory settings in the installer to your current DB. As long as you make sure to NOT initialize the DB cluster you should be able to reinstall postgresql and use the exact same \data folder in your new installation.


1) Install the same version of PostgreSQL as your current DB using these instructions - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=177
2) If you have moved/installed your DB to a non-default location, please make sure to change the 'Data Directory' path during the installation.
3) Uncheck the [ ] Initialize Database Cluster

Antix
11-06-2009, 06:01 PM
Ok I just resinstalled postrgres and I am now getting this error in the event logs:
<Data>2009-11-06 13:04:45 CST FATAL: could not create any TCP/IP
It says it is unable to create a listen socket as well. It looks like somethign is listening on 5432. I am going to try and change the port number.

Also, does postgres user need to be in admin group? UAC is disabled.


Any idea?

Antix
11-06-2009, 06:23 PM
Ok. I give up I am think I am going to reinstall postgres and holdem database and reimport. Can you send me the link to the install process?

fozzy71
11-06-2009, 09:40 PM
To backup everything - http://www.holdemmanager.net/forum/showthread.php?t=20754

To reinstall postgresql and a clean db: http://forums.holdemmanager.com/showthread.php?t=20755