pg_resetxlog question
От
Andrew Rawnsley
Тема
pg_resetxlog question
Дата
Msg-id
DB3F2EE2-D5DB-4240-8E71-CA367EEEDF20@ravensfield.com
Ответ на
Re: temporary tables ? (Zlatko Matic)
Список
Дерево обсуждения
Query planner refuses to use index Kilian Hagemann <hagemann1@egs.uct.ac.za>
Re: Query planner refuses to use index Martijn van Oosterhout <kleptog@svana.org>
Re: Query planner refuses to use index Janning Vygen <vygen@gmx.de>
Re: Query planner refuses to use index Kilian Hagemann <hagemann1@egs.uct.ac.za>
Re: Query planner refuses to use index Michael Fuhr <mike@fuhr.org>
Re: Query planner refuses to use index Kilian Hagemann <hagemann1@egs.uct.ac.za>
Re: Query planner refuses to use index Michael Fuhr <mike@fuhr.org>
Re: Query planner refuses to use index Kilian Hagemann <hagemann1@egs.uct.ac.za>
Re: Query planner refuses to use index Tom Lane <tgl@sss.pgh.pa.us>
Re: Query planner refuses to use index Kilian Hagemann <hagemann1@egs.uct.ac.za>
(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 по дате отправления
