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(at)bwkip(dot)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(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
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org

--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> (... have gone from d-i being barely usable even by its developers
> anywhere, to being about 20% done. Sweet. And the last 80% usually takes
> 20% of the time, too, right?) -- Anthony Towns, debian-devel-announce