> Shut down the postmaster and then copy the entire db (including pg_log
> file) and it should work. The catch is to make sure pg_log is in sync
> with your table files.
I would rather not leave my database down long enough to copy the entire db
(3.5GB). I have control over when changes are applied to this table. If I
restart the database and make certain no updates/inserts/deletes occur then
will all info be flushed from the pg_log file? If not, how about if I first
vacuum the table?
