| 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: | 2006-11-27 19:36:02 |
| Message-ID: | 456B3E22.8000308@amsoftwaredesign.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Ribe | 2006-11-27 19:37:11 | Re: IS it a good practice to use SERIAL as Primary Key? |
| Previous Message | psql | 2006-11-27 19:30:21 | Re: IS it a good practice to use SERIAL as Primary Key? |