Re: Please HELP - URGENT - transaction wraparound error

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Please HELP - URGENT - transaction wraparound error
Дата
Msg-id 823.1130688328@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Please HELP - URGENT - transaction wraparound error  (John Sidney-Woollett <johnsw@wardbrook.com>)
Ответы Re: Please HELP - URGENT - transaction wraparound error  (John Sidney-Woollett <johnsw@wardbrook.com>)
Список pgsql-general
John Sidney-Woollett <johnsw@wardbrook.com> writes:
> I decided to switch over to the slave which is now our live database.
> the old master with the problem has already been re-inited (although I
> have a cold backup of the data dir), plus dump files that I can restore
> from.

You panicked much too quickly and destroyed the evidence ... unless by
"cold backup" you mean a filesystem backup, in which case what you
should do is restore that and take a look at what's in its pg_database.
I think there's no question that there is some omission in your vacuuming
procedures, and you need to find out what it is.

            regards, tom lane

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

Предыдущее
От: Lincoln Yeoh
Дата:
Сообщение: Re: mysql replace in postgreSQL?
Следующее
От: Nico Grubert
Дата:
Сообщение: Sorting problems with SELECT * FROM table WHERE name LIKE 'Ö%'