Re: [HACKERS] logical replication connection information management

2016-10-14 Thread Petr Jelinek
On 12/10/16 19:59, Peter Eisentraut wrote: > > So functionality-wise, this looks pretty good, but there is some > awkwardness in how to wire this into the existing facilities, since a > server, also known as a foreign server, is currently tied to a foreign > data wrapper. I have currently

Re: [HACKERS] logical replication connection information management

2016-10-12 Thread Alvaro Herrera
Peter Eisentraut wrote: > An idea is to make the foreign server concept more general and allow > it to exist independently of a foreign data wrapper. Then create more > specific syntax like > > CREATE SERVER node1 FOR SUBSCRIPTION OPTIONS ( ... ); > > or > > CREATE SUBSCRIPTION SERVER

[HACKERS] logical replication connection information management

2016-10-12 Thread Peter Eisentraut
I want to discuss the connection information management aspect of the logical replication patch set that is currently being proposed (https://commitfest.postgresql.org/10/701/). To review, the user-visible interfaces center around -- on sending end CREATE PUBLICATION mypub FOR TABLE tbl1,