On Mon, Sep 12, 2011 at 3:56 PM, Oliver Kohll <oliver.li...@gtwm.co.uk> wrote: > Hi, great to see unlogged tables. There was discussion in the lists a while > ago about various options for what would happen on server restart. I > understand after a crash they'll be truncated but what about after a clean > restart? Are they guaranteed to retain all committed data? If so I'll > definitely use them for frequently written logs, if not I may still do so but > will need some extra backup steps.
Per the documentation they are only cleared following an unclean shutdown...(http://www.postgresql.org/docs/9.1/static/sql-createtable.html) merlin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
