Sounds like you just need to delete /usr/local/pgsql/data/postmaster.pid
or /var/lib/pgsql/data/postmaster.pid and exectute service postgresql start.
J
danfisher@bwkip.com wrote:
>After a powerfailure of 10hours I have got my database server back up and
>the phpBB2 that a site uses is not working. Here is the error.
>
>Warning: pg_connect() unable to connect to PostgreSQL server: could not
>connect to server: Connection refused Is the server running on host
>database.lhasi.org and accepting TCP/IP connections on port 5432? in
>/var/www/html/dealingwithcrohns/phpBB2/db/postgres7.php on line 79
>phpBB : Critical Error
>
>Could not connect to the database
>
>
>
>The machine is a RH9 box with the latest postgres running from redhat update.
>
>I have webmin on the machine which shows the databases there but i keep
>getting this error
>
>
>The machine didn't come up with any errors or bad blocks with the auto fsck
>so i am confused.
>
>Can anyone help?
>
>-Dan
>I am patient...its the other guys you gotta blame ;)
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>
--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL