The logical replication features in 9.4 look very promising as an
alternative to the binary replication that requires an identical schema on
both ends. There's no reason that the thing you're replicating to couldn't
be something like RabbitMQ or Storm.
I've been playing with a JSON-based decoder p
Hi all,
I'm trying to learn about how to subscribe to events in a logical
replication slot. I'm finding that the documentation is sparse and mostly
focused on binary WAL replication. I'd like to get a toy example working
where I can see changes in my terminal. I'm able to create a replication
sl
umentation/logicaldecoding-example.html
.
On Sat, Jan 10, 2015 at 4:48 AM, Michael Paquier
wrote:
> On Sat, Jan 10, 2015 at 9:22 AM, Brent Tubbs
> wrote:
> > psql "dbname=postgres replication=database user=postgres" -c
> > "START_REPLICATION SLOT foobar LOGICAL 0
> On 2015-01-10 10:24:56 -0800, Brent Tubbs wrote:
> > That's working! The blog posts I linked earlier
>
> Which blogpost is that? At least this thread doesn't seem to contain a
> reference.
>
> > made me think that I had to explicitly call START_REPLICA
Thanks for your help here, on those blog posts, and in the pg_plugins repo.
This weekend I was able to make https://bitbucket.org/btubbs/decoder_json/
a thing.
On Sun, Jan 11, 2015 at 12:53 AM, Michael Paquier wrote:
> On Sun, Jan 11, 2015 at 7:38 AM, Brent Tubbs
> wrote:
> > I
