Re: copy expensive local view to an RDS instance

>> A very quick search shows that rds supports dblink
> Then I'd need to open our servers to external visits.

This is sort of getting away from Postgres, but if the RDS instance is
in a VPC, you could put a VPN on the VPC so dblink wouldn't have to go
over the open Internet.

Paul

On Tue, May 6, 2014 at 8:07 AM, Marcus Engene <mengpg2(at)engene(dot)se> wrote:
> On 06/05/14 16:58, bricklen wrote:
>>
>>
>> A very quick search shows that rds supports dblink, so perhaps that would
>> work.
>> http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_PostgreSQL.html
>
>
> Then I'd need to open our servers to external visits. It would be lovely if
> dblink_exec could push a subselect of data instead instead of pull from RDS.
> Does this make sense?
>
>
> Thanks,
> Marcus
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

--
_________________________________
Pulchritudo splendor veritatis.