So in my last setup i had Vista x64 installed on partition c: and postgres installed on its own partition d:

I decided to go back to XP. So I formatted c: and installed XP on there. Then i downloaded postgres and tried to install it on top of my old install on d:

It all installs nicely, the problem is that when i try to connect to the server through pgadmin it tells me that connection fails and a message about the server not listening or something.

Interestingly, if i move the old postgres directory to another location and do a fresh install, i can connect to the server just fine. But i really need to get my old databases back so that's not an option.

Any ideas?

Looks like the server doesn't start. When i try to "start server" via Start>programs>postgres>start server i get:


The postgresql-8.3 service is starting..........................................
.......
The postgresql-8.3 service could not be started.

The service did not report an error.

More help is available by typing NET HELPMSG 3534.

The start command returned an error (2)

Press <return> to continue...

i did another test...

-Install postgres on new partition. Installs fine & service starts.
-Stop service. Delete data folder. Copy data folder from old postgres.
-Restart service. Service DOESN'T start. Same error message as before.


This is driving me nuts. I really need to recover old data. That's 80GB worth of hands in there.

I don't think this is supposed to work like you think it should. You can't just keep the datafiles and install it on an other OS. You should export your DB properly first by using pg_dumpall and then reimporting it.

This post seems to indicate it might be fixable by removing a .pid file.

I'm sure there is a way. I'm just saying that I'm not surprised this doesn't just work. It will be a bit more complicated than that.

from what i've read, if you have the your old postgres folder untouched, you just install postgres on top of it and it will recover you old data (as long as you're installing the same version)

iStrong,

Uninstall PostgreSQL. Restart. Create a directory where you want to reinstall it. Copy your data directory to that directory. Install PostgreSQL to that directory as normal. During setup it will tell you that if you want to use the existing database you do not need to "intdb." Which is fine. Just leave all settings as default, and install. You might then have to start the service manually, although HM can do that for you too.

^This sounds about right, IIRC.

Search for posts/replies by _dave_ in threads from this spring/summer. He helped TeddyFBI and a few other people with the process of moving/reinstalling the old data folder.

Dont worry iStrong, its exactly correct I assure you. I happen to have done it three times just today because of a hardware issue. Its really simple.

I've tried this as well.... but the service doesn't start.

yeah. i remembered about this thread and have checked it already...

What does the Event Viewer say? Control Panel -> administrative tools

2008-11-11 14:41:10 GMT FATAL: could not create shared memory segment: 8
2008-11-11 14:41:10 GMT DETAIL: Failed system call was MapViewOfFileEx.

there is this one too...
pg_ctl: PID file "D:/PostgreSQL/8.3/data/postmaster.pid" does not exist

Sorry, have to pass on this

iSTRONG, i had the same problem today. I made the mistake to install 2 concurrent versions of postgres - i just forgot to uninstall the old postgres. After i uninstalled the newer version everything was fine again.

Are you sure that you have only *one* postgres installed?

Mauzekater,

Both old and new versions are 8.3.x so yes, there is only one version of postgres.

If i understand correctly,you are running 2 postgres servers at the same time, both with the same release number?

*Bump*
Did this ever get fixed, im having a really similar problem

Just started having the same problem, any solutions?

You can blame the auto windows updates. :mad;


First try a simple reboot.

If no help, try this:

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

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

If you have Vista, please verify that UAC is still off. - http://www.holdemmanager.net/faq/afmmain.aspx?faqid=73. If it is on, please turn it off and reboot.

Add exceptions to the windows firewall, even if it is off. If you have a 3rd party firewall, uninstall it completely before installing HM/SQL - http://www.holdemmanager.net/faq/afm...aspx?faqid=171

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

1) http://www.holdemmanager.net/faq/afm....aspx?faqid=34
2) http://www.holdemmanager.net/forum/s...ead.php?t=8261

If that doesn't help at all we may want to schedule a remote support session to assist you.