From: Dimitri Fontaine <dimitri@2ndQuadrant.fr>
To: Craig James <craig_james@emolecules.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Postgresql 8.4 replication using Londiste
Organization: 2ndQuadrant
References: <4DEFD00C.8030600@nasa.gov> <4DEFDB81.8060003@emolecules.com>
User-Mail-Address: dimitri@2ndQuadrant.fr
Date: Tue, 16 Aug 2011 00:50:18 +0200
In-Reply-To: <4DEFDB81.8060003@emolecules.com> (Craig James's message of "Wed,
	08 Jun 2011 13:28:49 -0700")
Message-ID: <m21uwms311.fsf@2ndQuadrant.fr>
User-Agent: Gnus/5.110018 (No Gnus v0.18) Emacs/24.0.50 (darwin)
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

Craig James <craig_james@emolecules.com> writes:
> On the other hand, I've noticed that Londiste doesn't know when you chang=
e a
> table.  You might be able to create your one-column table (plus PK), start
> replication with Londiste, then do ALTER TABLE to add the rest of the
> columns.  A hack for sure.

And it stopped working somewhere in the 2.1 branch, I would guess by
2.1.9 from memory.  Now the trigger notices when you ALTER TABLE and
will queue events with the new columns by itself.  Well, that might also
depend on which trigger you use, but the default one is now smart
enough.

Skytools3 ahead!=C2=A0:)

Regards,
--=20
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support