From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Tom Lane <tgl(at)svr1(dot)postgresql(dot)org> |
Cc: | pgsql-committers(at)postgresql(dot)org |
Subject: | Re: pgsql: WAL must log CREATE and DROP DATABASE operations |
Date: | 2005-03-23 02:49:42 |
Message-ID: | 200503230249.j2N2ng901088@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
Added to TODO:
* Allow WAL replay of CREATE TABLESPACE to work when the directory
structure on the recovery computer is different from the original
---------------------------------------------------------------------------
Tom Lane wrote:
> Log Message:
> -----------
> WAL must log CREATE and DROP DATABASE operations *without* using any
> explicit paths, so that the log can be replayed in a data directory
> with a different absolute path than the original had. To avoid forcing
> initdb in the 8.0 branch, continue to accept the old WAL log record
> types; they will never again be generated however, and the code can be
> dropped after the next forced initdb. Per report from Oleg Bartunov.
> We still need to think about what it really means to WAL-log CREATE
> TABLESPACE commands: we more or less have to put the absolute path
> into those, but how to replay in a different context??
>
> Tags:
> ----
> REL8_0_STABLE
>
> Modified Files:
> --------------
> pgsql/src/backend/commands:
> dbcommands.c (r1.148.4.1 -> r1.148.4.2)
> (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/dbcommands.c.diff?r1=1.148.4.1&r2=1.148.4.2)
> pgsql/src/include/commands:
> dbcommands.h (r1.36 -> r1.36.4.1)
> (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/commands/dbcommands.h.diff?r1=1.36&r2=1.36.4.1)
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2005-03-23 02:49:43 | pgsql: Add: > * Allow WAL replay of CREATE TABLESPACE to work when the |
Previous Message | Bruce Momjian | 2005-03-23 02:41:30 | pgsql: Add: > o Update pg_dump and psql to use the new COPY libpq API |