On 4/30/17 20:31, Andres Freund wrote:
> On 2017-04-26 23:41:51 +0200, Petr Jelinek wrote:
>> Yes that's result of how logical replication slots work, the transaction
>> that needs to finish is your transaction. It can be worked around by
>> creating the slot manually via the SQL interface for example and create
>> the subscription using WITH (NOCREATE SLOT, SLOT NAME = 'your slot') .
>
> Is there any chance the creation of the slot could be moved ahead, to
> before an xid has been assigned?
The trend has rather been to do most of the stuff before creating the
slot, so that all the error checking is done. See for example
dcb39c37c1d3b90115e1501af8efb7af59c341c3.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services