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: Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com>
  • To: pgsql-general(at)postgresql(dot)org
  • Subject: Re: fatal error on 8.1 server
  • Date: Mon, 27 Nov 2006 13:36:02 -0600
  • Message-id: <456B3E22(dot)8000308(at)amsoftwaredesign(dot)com>

Alvaro Herrera wrote:
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.

Yep, I saw that in the docs, now I am just having problems finding a standalone backend, not sure what that means.

--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration



Home | Main Index | Thread Index

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