| From: | "Marc Mamin" <M(dot)Mamin(at)intershop(dot)de> |
|---|---|
| To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "PostgreSQL general" <pgsql-general(at)postgresql(dot)org>, "Josh Berkus" <josh(at)agliodbs(dot)com> |
| Subject: | Re: Survey on backing up unlogged tables: help us with PostgreSQL development! |
| Date: | 2010-11-17 22:46:10 |
| Message-ID: | C4DAC901169B624F933534A26ED7DF31034BB90B@JENMAIL01.ad.intershop.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
yep,
but I'll miss this as I only use WAL for crash recovery...
regards,
Marc Mamin
-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Mittwoch, 17. November 2010 23:40
To: Marc Mamin
Cc: PostgreSQL general; Josh Berkus
Subject: Re: [GENERAL] Survey on backing up unlogged tables: help us
with PostgreSQL development!
"Marc Mamin" <M(dot)Mamin(at)intershop(dot)de> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ivan Voras | 2010-11-17 23:06:54 | Re: Survey on backing up unlogged tables: help us with PostgreSQL development! |
| Previous Message | Tom Lane | 2010-11-17 22:39:56 | Re: Survey on backing up unlogged tables: help us with PostgreSQL development! |