Re: fatal error on 8.1 server - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: fatal error on 8.1 server
Date
Msg-id 20061127192904.GK9324@alvh.no-ip.org
Whole thread Raw
In response to fatal error on 8.1 server  (Tony Caduto <tony_caduto@amsoftwaredesign.com>)
Responses Re: fatal error on 8.1 server  (Tony Caduto <tony_caduto@amsoftwaredesign.com>)
Re: fatal error on 8.1 server  (Tony Caduto <tony_caduto@amsoftwaredesign.com>)
List pgsql-general
Tony Caduto wrote:
> I don't know what the exact version is but I am getting this:
>
> FATAL:  database is not accepting commands to avoid wraparound data loss
> in database "postgres"
>
> How can I recover from this and why woud this happen to the postgres
> database?  Has my server been hacked?  there should be no inserts or
> anything going on.

Stop the postmaster, start a standalone backend, and issue a
database-wide VACUUM on database postgres.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-general by date:

Previous
From: Tony Caduto
Date:
Subject: fatal error on 8.1 server
Next
From: "Harald Armin Massa"
Date:
Subject: Re: PostgreSQL doesn't accept connections when Windows Server is rebooted