Re: Lost databases

Martijn van Oosterhout wrote:
> Let's start with the version of postgresql you're using.
> Next, were you running VACUUM FULL regularly?
>
> It sounds like XID wraparound to me, no idea how to solve that. Got
> backups?
>
> On Wed, Nov 10, 2004 at 12:56:33PM +0200, Liviu BURCUSEL wrote:
>
>>Hi !
>>
>>I'm in the ultimate state of dispair. Over the night some of my
>>databases just disapeared. But they did not dissaper totally. I can
>>still connect to them but I cannot dump them. When doing a "select *
>>from pg_database" I see only 2 databases I hardly ever use (they are
>>used once in a couple of mounths). Template0 and template1 are missing.
>>All the databases that I currently use dissapeared!
>>
>>Please help me to restore the integrity of the system. I'm in dense fog
>>here :(
>>
>>Liviu
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 5: Have you checked our extensive FAQ?
>>
>>               http://www.postgresql.org/docs/faqs/FAQ.html
>
>
Only VACUUM FULL solves XID wraparound problem? I mean VACUUM FULL locks
the entire table.

How can I test if I am close to XID wraparround?

Kostis