Re: pg_dump: missing pg_database entry

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_dump: missing pg_database entry
Дата
Msg-id 22802.1150210759@sss.pgh.pa.us
обсуждение исходный текст
Ответ на pg_dump: missing pg_database entry  (gl@lbn.fr)
Ответы Re: pg_dump: missing pg_database entry  (gl@lbn.fr)
Список pgsql-general
gl@lbn.fr 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Peter Wilson
Дата:
Сообщение: Re: PostgreSQL and Apache
Следующее
От: "Carlos H. Reimer"
Дата:
Сообщение: XID comparations