Re: pg_receivexlog and replication slots

On 2014-07-11 11:08:48 +0200, Magnus Hagander wrote:
> Is there a particular reason why pg_receivexlog only supports using
> manually created slots but pg_recvlogical supports creating and
> dropping them? Wouldn't it be good for consistency there?

I've added it to recvlogical because logical decoding isn't usable
without slots. I'm not sure what you'd want to create/drop a slot from
receivexlog for, but I'm not adverse to adding the capability.

> I'm guessing it's related to not being exposed over the replication
> protocol?

It's exposed:
create_replication_slot:        /* CREATE_REPLICATION_SLOT slot PHYSICAL */        K_CREATE_REPLICATION_SLOT IDENT
K_PHYSICAL

Greetings,

Andres Freund

-- Andres Freund                       http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services