Search Postgresql Archives

Re: fatal error on 8.1 server

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux