Re: Mysterious table that exists but doesn't exist

Поиск
Список
Период
Сортировка
От Dale Fukami
Тема Re: Mysterious table that exists but doesn't exist
Дата
Msg-id CAAHkhS7qxhr4sJppwgHn7d0rQmZ1xK-E=jBdMGEE9SBQs+t_qw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Mysterious table that exists but doesn't exist  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general


Hm ... there was a fix in 9.0.12 that might be relevant to this:
http://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=5840e3181b7e6c784fdb3aff708c4dcc2dfe551d
Whether that explains it or not, 9.0.5 is getting long in the tooth;
you really need to think about an update.  Especially in view of
CVE-2013-1899.

 
Yeah, we've been in the process of planning the update in light of the security fix. We're likely just making the jump to 9.2 in the process so that'll be handled soon.


I think you should update your PG version and then resync your standbys
(ie, apply a fresh base backup) at the next convenient maintenance
window.

We did apply a fresh base backup last night to ensure our current standbys are in a good state. I was mostly wondering if there were some better way to continually monitor the state of our standbys on an ongoing basis aside from checking pg_last_xlog_receive_location, etc. I realize it's no small task but thought maybe there was something I had missed.

In the end, I think this just helps nudge our upgrade along :)

Thanks for all the help!
Dale

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

Предыдущее
От: Michael Nolan
Дата:
Сообщение: Re: How large can a PostgreSQL database get?
Следующее
От: Mike Roest
Дата:
Сообщение: Fetching Server configured port from C Module