Sync unlogged relations to disk after they have been reset. Unlogged relations are only reset when performing a unclean restart. That means they have to be synced to disk during clean shutdowns. During normal processing that's achieved by registering a buffer's file to be fsynced at the next checkpoint when flushed. But ResetUnloggedRelations() doesn't go through the buffer manager, so nothing will force reset relations to disk before the next shutdown checkpoint.
So just make ResetUnloggedRelations() fsync the newly created main forks to disk. Discussion: [email protected] Backpatch to 9.1 where unlogged tables were introduced. Abhijit Menon-Sen and Andres Freund Branch ------ REL9_4_STABLE Details ------- http://git.postgresql.org/pg/commitdiff/e26a920acb77b953d1034e243d6a8c7294dbd25d Modified Files -------------- src/backend/storage/file/reinit.c | 47 +++++++++++++++++++++++++++++++++++++ 1 file changed, 47 insertions(+) -- Sent via pgsql-committers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
