yep, but I'll miss this as I only use WAL for crash recovery... regards, Marc Mamin -----Original Message----- From: Tom Lane [mailto:tgl@xxxxxxxxxxxxx] Sent: Mittwoch, 17. November 2010 23:40 To: Marc Mamin Cc: PostgreSQL general; Josh Berkus Subject: Re: Survey on backing up unlogged tables: help us with PostgreSQL development! "Marc Mamin" <M.Mamin@xxxxxxxxxxxx> writes: > Will it be possible to switch from unlogged to logged ? Probably not, because it would completely confuse hot standby slaves (or anything else looking at the WAL replay stream). You can't just start issuing WAL records against an already-built table or index, because the WAL entries are deltas. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
