Problems w/PostgresSQL - Gambling and Poker Software Forum

Two Plus Two Forums Online Poker Sites & Marketplaces Poker Software General Software Discussion

Problems w/PostgresSQL

Post Reply Subscribe

...

04-19-2009 , 08:51 PM

skiierguy

centurion

Join Date: Jan 2005 Posts: 191

I've been having problems with Postgres for the past month or so, but the strangest thing is that it just all started happening one day w/o provocation. Applications like HEM, PokerGrapher, and PokerEV all suddenly stopped working one day, citing misc Postgres errors. Even stranger is that PTO works fine, and my PTO dbs are all Postgres! I've tried restarting the Postgres service to no avail, and I'm no database wiz so that was all I could think of.

I made a short video with Camtasia showing the error messages given by each application: http://tbaudio.com/poker/PostgresSQL_errors.wmv

I'm running Vista Home Premium with all current updates, and pretty sure my postgres version is 8.2.6. All poker software is up-to-date. Any help is greatly appreciated!

Quote

150% up to $2,000 Welcome Bonus on CoinPoker

Join the action now

Daily Rewards • Splash Pots • CoinRaces

04-19-2009 , 08:59 PM

fozzy71

Carpal \'Tunnel

Join Date: Mar 2007 Posts: 38,222

http://www.holdemmanager.net/faq/afmmain.aspx?faqid=34

http://208.109.95.123/faq/afmmain.aspx?faqid=171

It is also possible to install sql 8.3 right along side your 8.2 server. I used to use pto on sql 8.2 and hem on sql 8.3.

Quote

04-19-2009 , 09:10 PM

Dice Man

grinder

Join Date: Dec 2006 Posts: 410

All my problems with Postgres stopping - which i could never restart - were caused by Window update.

Quote

04-19-2009 , 09:19 PM

fozzy71

Carpal \'Tunnel

Join Date: Mar 2007 Posts: 38,222

Oh, right. I forgot about that (I am on XP).

Quote:

Originally Posted by rvg72

Hi, Microsoft released a patch last night that has caused some issues with the postgresql service for some people on Vista. The following steps seem to get around this problem if it happens to you:

1: Go to "C:\Windows\system32\drivers\etc" and open the "hosts" file with notepad

It might look something like this:
**************************************************
# Copyright (c) 1993-2006 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#
# This file contains the mappings of IP addresses to host names. Each
# entry should be kept on an individual line. The IP address should
# be placed in the first column followed by the corresponding host name.
# The IP address and the host name should be separated by at least one
# space.
#
# Additionally, comments (such as these) may be inserted on individual
# lines or following the machine name denoted by a '#' symbol.
#
# For example:
#
# 102.54.94.97 rhino.acme.com # source server
# 38.25.63.10 x.acme.com # x client host

::1 localhost
************************************************** ****

2: Enter "127.0.0.1 localhost" (without the quotes) at the bottom of the file
4: Save the file
5: Restart PostgreSQL service by clicking on Start Menu - Programs - Postgresql - Start Service

Thanks,

Roy

Quote

04-20-2009 , 12:08 PM

skiierguy

centurion

Join Date: Jan 2005 Posts: 191

That worked perfectly Fozzy, thanks!

Quote

150% up to $2,000 Welcome Bonus on CoinPoker

Join the action now

Daily Rewards • Splash Pots • CoinRaces

Post Reply Subscribe

...