Postgres 8.3.15 will not start

[awj94122]

Hello all. I know you seen messages like this or similar ones. My system crashed. I reinstalled PT3, and attempted to first find my old database with no success. I then attempted to create a new database in PT3,and got the following error:

Unable to create Postgres database PT3_2011_05_17_103312. Reason: Unable to login to database (template 1). Reason: Could not connect to server: Connection refused. Is the server running on host ??? and accepting conncetions on port 5432?

This error indicates postgres is either not loaded on the system or is not started, yes???

I then tried to reinstall postgres 8.3.15 I believe my older version was 8.3.4, and was no longer available on the website. I followed all the steps (multiple times) in in the PT3 tutorial for manual uninstall/reinstall for PostgreSQL 8.3 (Windows). The installation goes as far as trying to start the system and fails to do so. I have checked for and deactivated all known firewalls. I have checked for the postgre processes using ther Windows Task manager and they are abscent. I am running Windows XP SP3. Any help is appreciated.

Thanks.

awj94122

[kraada]

It's saying the server can't start - but that specific error can come up for a few reasons. Take a look in Event Viewer (click Start type Event Viewer and click on it) and in the Applications section you should see a PostgreSQL error there - double clicking on it will give more detailed error information.

[awj94122]

1. Where is the Event Viewer?

2. I found an install program for postgres v 8.3.4 in my PT3 directory. Is that normal or could it be causing part of the the problem. I deleted it and the postgres-int that was in tghe folder.

[WhiteRider]

1. ..click Start, type 'Event Viewer' and click on it.

It's saying the server can't start - but that specific error can come up for a few reasons. Take a look in Event Viewer (click Start type Event Viewer and click on it) and in the Applications section you should see a PostgreSQL error there - double clicking on it will give more detailed error information.

2. An installer will not cause any problems.

[evil gensis]

I am having that same error now. PT3 has been running completely fine, I used it yesterday and never had any problems. I loaded it up today and I couldn't install the Beta update nor can I open it at all. I am running on a Mac and brought it up but no idea what I am looking for. Please help

[kraada]

In Applications --> Utilities --> Console Viewer do you see any errors relating to PostgreSQL?

[evil gensis]

Yes
5/26/11 4:49:00 PM com.apple.launchd[1] (com.edb.launchd.postgresql-8.4[1133]) Exited with exit code: 1
5/26/11 4:58:21 PM com.edb.launchd.postgresql-8.4[1194] 2011-05-26 20:58:21 GMTDETAIL: Permissions should be u=rwx (0700).
5/26/11 4:49:20 PM com.edb.launchd.postgresql-8.4[1137] 2011-05-26 20:49:20 GMTFATAL: data directory "/Library/PostgreSQL/8.4/data" has group or world access

Are the only ones I see.

Also this is verison 8.4 PostgresSQL

[kraada]

You changed the permissions on the /Library/PostgreSQL directory - you'll need to change them back to their original settings for the database to start up properly.

You can do this via Terminal (Applications -> Utilities -> Terminal) by running the command:

sudo chmod -r 700 /Library/PostgreSQL/8.4/

You'll be prompted for your Mac password - just type and hit enter; it doesn't show *s for security purposes.

[evil gensis]

chmod: 700: No such file or directory

[kraada]

My apologies for the typo that command should be:

sudo chmod -R 700 /Library/PostgreSQL/8.4/