Re: copy expensive local view to an RDS instance - Mailing list pgsql-general

From Paul Jungwirth
Subject Re: copy expensive local view to an RDS instance
Date
Msg-id CA+6hpam1hTFq3N=q8Ske26K-9PYPdEi1Ta+S3MzX6QFRJCousA@mail.gmail.com
Whole thread Raw
In response to Re: copy expensive local view to an RDS instance  (Marcus Engene <mengpg2@engene.se>)
List pgsql-general
>> 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@engene.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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general



--
_________________________________
Pulchritudo splendor veritatis.


pgsql-general by date:

Previous
From: Marcus Engene
Date:
Subject: Re: copy expensive local view to an RDS instance
Next
From: Tim Kane
Date:
Subject: DDL statement blocked on long-running query with no runtime dependancy