Re: Foreign table & Connection reset by peer

2019-02-24 Thread Lukáš Sobotka
encrypted connection, because in both way the connection stayed defined in pg_stat_activity after query on foreign table. so 23. 2. 2019 v 22:48 odesílatel Adrian Klaver napsal: > On 2/23/19 1:28 PM, Lukáš Sobotka wrote: > > Hi guys, > > > > I would be grateful for some advice a

Foreign table & Connection reset by peer

2019-02-23 Thread Lukáš Sobotka
Hi guys, I would be grateful for some advice about foreign tables. I attached simplified script describing the problem for better understanding. What I am trying to do: I am copying tables between two databases and for copying is used function which are called from bash script. What is problem:

Trouble with postgres_fdw & dblink extensions

2018-11-15 Thread Lukáš Sobotka
Hi guys, I would be grateful for some help. I am writing you because I am confused about using data foreign wrappers and dblink. I attached simplified script describing the problem. What I am trying to do? I have two databases and I need to copy table from local database to the remote one. For co