Tom Lane a écrit : > gl@xxxxxx 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
