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
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.