Another connection problem

[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

[kraada]

Have you tried rebooting the machine since this problem started?

[aderpalen]

yes, several times. doesn't help.

[kraada]

Have you tried reverting the changes in the configuration file?

[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.

[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.

[aderpalen]

There is a file called postgresql.conf.20101006113645

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

[kraada]

Rename the postgresql.conf file postgresql.conf-renamed and rename postgresql.conf.20101006113645 to postgresql.conf. Then attempt to restart the server.

[aderpalen]

That worked. Thanks a lot!