Page 1 of 1

Another connection problem

PostPosted: Wed Oct 06, 2010 8:13 am
by aderpalen
Hi

My computer was running very slow when using PT3, HEM and a poker client at the same time. I tried the "Performance tuning PostgreSQL" (viewtopic.php?f=45&t=10393) and the "Performance tuning: Hard Drives" (viewtopic.php?f=45&t=10489). After completing all the steps in these guides I can no longer open up PT3. I get the message "Error connecting to default database. Please select one of the valid databases below or create a new one."

It seems like PostgreSQL is not running and when trying to start it I get an error message saying it was not possible to start PostgreSQL server 8.4 and that the service did not report any errors. The event viewer gives the following error messages:
2010-10-06 13:56:43 CESTFATAL: could not create shared memory segment: 8
2010-10-06 13:56:43 CESTDETAIL: Failed system call was MapViewOfFileEx.


Thanks
//Patrik

Re: Another connection problem

PostPosted: Wed Oct 06, 2010 9:39 am
by kraada
Have you tried rebooting the machine since this problem started?

Re: Another connection problem

PostPosted: Wed Oct 06, 2010 9:47 am
by aderpalen
yes, several times. doesn't help.

Re: Another connection problem

PostPosted: Wed Oct 06, 2010 12:22 pm
by kraada
Have you tried reverting the changes in the configuration file?

Re: Another connection problem

PostPosted: Wed Oct 06, 2010 12:50 pm
by aderpalen
I used the "recommended method" with EnterpriseDB Tuning Wizard. Didn't change any configuration files. I reverted the changes for hard drive performance though, which didn't help.

Re: Another connection problem

PostPosted: Wed Oct 06, 2010 2:33 pm
by kraada
Actually that does change the configuration file, it just doesn't do it by hand. Look in the C:\Program Files (x86)\PostgreSQL\8.4\data directory - there may well be a postgresql.conf backup file there. If so try moving that over the postgresql.conf you have now and see if the server will start then.

Re: Another connection problem

PostPosted: Wed Oct 06, 2010 2:43 pm
by aderpalen
There is a file called postgresql.conf.20101006113645

What do you mean I should do with this file? Not sure that I understand.

Re: Another connection problem

PostPosted: Wed Oct 06, 2010 4:41 pm
by kraada
Rename the postgresql.conf file postgresql.conf-renamed and rename postgresql.conf.20101006113645 to postgresql.conf. Then attempt to restart the server.

Re: Another connection problem

PostPosted: Thu Oct 07, 2010 6:16 am
by aderpalen
That worked. Thanks a lot!