pg_resetxlog question
От | Andrew Rawnsley |
---|---|
Тема | pg_resetxlog question |
Дата | |
Msg-id | DB3F2EE2-D5DB-4240-8E71-CA367EEEDF20@ravensfield.com обсуждение исходный текст |
Ответ на | Re: temporary tables ? ("Zlatko Matic" <zlatko.matic1@sb.t-com.hr>) |
Ответы |
Re: pg_resetxlog question
|
Список | pgsql-general |
(v 7.4.8 on linux) pg_resetxlog question... I have a idle database (idle = no writes for @12 hours, everything committed, full dump in between) that was shut down cleanly, then imaged to another machine. Forgetting a certain flag in the rsync command, my symlinked pg_xlog didn't make the trip, and I didn't notice until the originals were gone. (Oh, the embarrassment...) I ran pg_resetxlog, and reindexed the system tables. Everything seems fine. Both documentation and chatter on the lists imply that I should be suspect of the database. Given the particulars mentioned above (idleness, clean shutdown, etc), would that be true in this case? -------------------- Andrew Rawnsley Chief Technology Officer Investor Analytics, LLC (740) 587-0114 http://www.investoranalytics.com
В списке pgsql-general по дате отправления: