Re: pgsql: WAL must log CREATE and DROP DATABASE operations

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

In response to

Browse pgsql-committers by date

  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