Can't start service after reinstalling windows

[VladimirN]

So my Windows 'broke' and I installed new Windows 7 while I got the opportunity.
Postgres was still on the other drive, but it stopped working after the new install.

Have to note that I could not uninstall postgres over the Control Panel list of programs because they were all gone from it.

So I installed it again, over the existing one (to preserve the database).
Installation went fine but it won't Start the Service, and I did turned off UAC and even turned off Firewall completelly.

When I Start the Service it just turns the window on and off in part of a second, or it's starting it for a few minutes and then just turns off.

This may help as well:
When I start "psql to 'postgres'" I get this message: "psql: could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "something" and accepting TCP/IP connections on port 5432?"

[kraada]

Please take a look in the pg_log folder (C:\Program Files\PostgreSQL\8.3\data\pg_log) and paste the contents of the last couple of files here; they should illuminate the problem somewhat.

[VladimirN]

postgresql-2009-11-22_110150:

Code: Select all

2009-11-22 11:01:50 LOG:  database system was shut down at 2009-11-22 03:23:18

2009-11-22 11:01:50 FATAL:  the database system is starting up

2009-11-22 11:01:50 LOG:  checkpoint record is at 6/30895A10

2009-11-22 11:01:50 LOG:  redo record is at 6/30895A10; undo record is at 0/0; shutdown TRUE

2009-11-22 11:01:50 LOG:  next transaction ID: 0/8699182; next OID: 37031

2009-11-22 11:01:50 LOG:  next MultiXactId: 1; next MultiXactOffset: 0

2009-11-22 11:01:51 LOG:  database system is ready

2009-11-22 15:14:26 LOG:  received fast shutdown request

2009-11-22 15:14:27 LOG:  shutting down

2009-11-22 15:14:27 LOG:  database system is shut down

2009-11-22 15:14:27 LOG:  logger shutting down



That's the last one I got here, and the one before that is the same, except for some different numbers.

These seems to be from 2 days ago tho, and I reinstalled Windows yesterday and tinkered with postgres last night.

[kraada]

Normally situations like this are a result of an overzealous firewall/anti-virus; take a look at our Firewall Troubleshooting Guide and see if that helps you get things working again.

[VladimirN]

Did that and still no results.
I even turned Firewall and Antivirus completely off and nothing still.

[kraada]

In that case, please create a support ticket and we will get things sorted out for you.

[VladimirN]

While waiting for the reply I tried installing the latest version of postgres and it worked.
I guess 8.3.5. Doesnt work on Windows 7 64-bit.

I installed the 8.3.5 before, because I read that my current database wouldn't work on 8.4.x.

Will my old database work if I install 8.4. postgres over my current 8.3.5 PostgreSQL Directory?
Or do I have to import all those hands again in the new database?

[kraada]

8.3.8 should work on Win7; at least, I've tested that one and seen it work, personally.

If you upgrade from 8.3.x to 8.4.x you'll need to backup your 8.3 database then restore it in 8.4, or create a new database in 8.4 and reimport everything; it's a PostgreSQL restriction here and there's nothing we can do about that.