Re: Errors after power failure

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(at)bwkip(dot)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(at)postgresql(dot)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(at)commandprompt(dot)com - http://www.commandprompt.com
> Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster