Re: copy expensive local view to an RDS instance

Поиск
Список
Период
Сортировка
От Paul Jungwirth
Тема Re: copy expensive local view to an RDS instance
Дата
Msg-id CA+6hpam1hTFq3N=q8Ske26K-9PYPdEi1Ta+S3MzX6QFRJCousA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: copy expensive local view to an RDS instance  (Marcus Engene <mengpg2@engene.se>)
Список 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 по дате отправления:

Предыдущее
От: Marcus Engene
Дата:
Сообщение: Re: copy expensive local view to an RDS instance
Следующее
От: Tim Kane
Дата:
Сообщение: DDL statement blocked on long-running query with no runtime dependancy