Server Not Listening...

[puyanwei]

Hi,

I'm getting this error now when trying to start postgres;

"Server doesn't listen

could not connect to server: connection refused. Is the server running on host [ip address] and accepting TCP?IP connections on port 5432?"

I've tried restarting windows, I'm running both programs as admin, and tried to restart the server. My firewall isn't on and I use AVG for protection. I'm on Windows XP using Boot Camp on a Macbook.

Looked at event viewer and got some errors;

1. 2009-11-20 10:29:38 GMTFATAL: could not create lock file "postmaster.pid": Permission denied

2. pg_ctl: PID file "C:/Program Files/PostgreSQL/8.4/data/postmaster.pid" does not exist

3. Is server running?

[kraada]

Do you have any actual data in the database? If not, reinstalling PostgreSQL should resolve this problem fairly easily.

If you do, you'll need to check the permissions on the C:\Program Files\PostgreSQL directory - it sounds like the postgres user does not have write permissions for some reason. Once the postgres user has full privileges to that directory tree everything should work properly.

[puyanwei]

All my folders in Program Files are marked as "read only". If I change it under properties it changes back to read only. However, apparently after some googling its normal, and the actual files are not read only, just the folders. I dunno if that makes a difference. Either way I still cant change the Postgres folder to not be read only, I'm the Admin but it wont save.

[kraada]

Right click on the PostgreSQL folder, click Properties. Go to the Security tab, click Advanced. Click to expand the options there, then click Find Now. Look for the postgres user in the list of users. Click on them, then click OK. Click on the postgres user from the list at the top and give them Full Access. That should fix it.

[puyanwei]

Sorry there is no security tab. I'm using Windows XP.

[kraada]

Follow these steps, then you'll see it.

[puyanwei]

Thanks for the promp replies, much appreciated...

I've turned off file sharing, and restarted. Still not working.

[kraada]

Follow this link and request a remote session (and link to this thread in the ticket) and we'll schedule a time to get things fixed for you directly.

[puyanwei]

I solved the problem by reinstalling Postges and deleting the data folders and reimporting them. Thanks anyway.

[WhiteRider]

Good work - thanks for letting us know.