Re: [GENERAL] CREATE FOREIGN TABLE difficulties

2017-06-15 Thread Paul Lavoie
The ‘does not actually create’ the table was the piece I was missing. I wasn’t sure either way from reading the documentation for the command, but makes sense from a perspective of trying to keep the databases independent. One of the reasons I went down this path was the hopes to not need to

Re: [GENERAL] CREATE FOREIGN TABLE difficulties

2017-06-15 Thread Adrian Klaver
On 06/15/2017 09:49 AM, Paul Lavoie wrote: Hi, Long time user, new poster… For assorted reasons I’ve decided to shard a database across multiple instances of postgresql running on the same machine. I’ve set up a lot of children servers with a ‘fdw’ user to work with the foreign data wrapper

[GENERAL] CREATE FOREIGN TABLE difficulties

2017-06-15 Thread Paul Lavoie
Hi, Long time user, new poster… For assorted reasons I’ve decided to shard a database across multiple instances of postgresql running on the same machine. I’ve set up a lot of children servers with a ‘fdw’ user to work with the foreign data wrapper and created the child database along with a