Re: copy expensive local view to an RDS instance

Поиск
Список
Период
Сортировка
От bricklen
Тема Re: copy expensive local view to an RDS instance
Дата
Msg-id CAGrpgQ8rj-Oy9Rr_z7G-iqj0u03iv2w6uvUuvrmFX1PJMSHAdQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: copy expensive local view to an RDS instance  (Marcus Engene <mengpg2@engene.se>)
Ответы Re: copy expensive local view to an RDS instance
Список pgsql-general
Дерево обсуждения
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?

Is the idea to pull data from the RDS to your local machine? If so, dblink or possibly plproxy[1] should be able to do that.

[1] https://wiki.postgresql.org/wiki/PL/Proxy

В списке pgsql-general по дате отправления:

Предыдущее
От: Marcus Engene
Дата:
Сообщение: Re: copy expensive local view to an RDS instance
Следующее
От: Marcus Engene
Дата:
Сообщение: Re: copy expensive local view to an RDS instance