Re: Shared hosting with FDW on AWS RDS

2019-02-15 Thread Bruno Lavoie
On 2019-02-14 10:21 p.m., Bruce Momjian wrote: On Sun, Feb 10, 2019 at 03:19:48PM -0800, Paul Jungwirth wrote: On 2/10/19 2:57 PM, auxsvr wrote: We'd like to configure an RDS server for shared hosting. The idea is that every customer will be using a different database and FDW will be

Re: Shared hosting with FDW on AWS RDS

2019-02-14 Thread Bruce Momjian
On Sun, Feb 10, 2019 at 03:19:48PM -0800, Paul Jungwirth wrote: > On 2/10/19 2:57 PM, auxsvr wrote: > >We'd like to configure an RDS server for shared hosting. The idea is that > >every customer will be using a different database and FDW will be > >configured, so that the remote tables have

Re: Shared hosting with FDW on AWS RDS

2019-02-10 Thread Paul Jungwirth
On 2/10/19 2:57 PM, auxsvr wrote: We'd like to configure an RDS server for shared hosting. The idea is that every customer will be using a different database and FDW will be configured, so that the remote tables have access to the full data I've set up something like this before (but on

Shared hosting with FDW on AWS RDS

2019-02-10 Thread auxsvr
Hi, We'd like to configure an RDS server for shared hosting. The idea is that every customer will be using a different database and FDW will be configured, so that the remote tables have access to the full data, but materialized views will be pulling from them data specific to each customer.