Tom Lane a écrit : > [EMAIL PROTECTED] writes: > > I'm experiencing a strange problem with PostgreSQL 7.4.9. > > One of my database production servers has 2 large databases, it's still > > possible to connect to them and pass queries, but the pg_database > > system table is empty, which prohibits such actions as dumping the > > databases. > > Sounds like XID wraparound. Does vacuuming pg_database make the problem > go away? If so, I'd recommend doing database-wide vacuums in all your > databases ASAP. And then instituting a regular vacuum maintenance schedule. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org
Thanks for your answers. Indeed, the vacuum schedule was not regularly executed. Manually launching the procedure solved the problem. Regards, GL ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
