Re: Errors after power failure

Look through the postgresql log. It will tell you what's going wrong.

On Wed, Jan 14, 2004 at 05:49:57PM -0500, danfisher@bwkip.com wrote:

I have deleted the pid and restarted the postgresql and it is starting
fine. It just appears to not be accepting connections. I had to rebuild
the server the last time this happened. Starting to be a pain.

Anyone have ideas?

-Dan

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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/

I have deleted the pid and restarted the postgresql and it is starting
fine. It just appears to not be accepting connections. I had to rebuild
the server the last time this happened. Starting to be a pain.

Anyone have ideas?

-Dan