Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: fatal error on 8.1 server


  • From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
  • To: Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com>
  • Cc: pgsql-general(at)postgresql(dot)org
  • Subject: Re: fatal error on 8.1 server
  • Date: Mon, 27 Nov 2006 16:29:05 -0300
  • Message-id: <20061127192904(dot)GK9324(at)alvh(dot)no-ip(dot)org>

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



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group