Postgres Pro
Downloads
Home   >   mailing lists

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

From bricklen
Subject Re: copy expensive local view to an RDS instance
Date
Msg-id CAGrpgQ8rj-Oy9Rr_z7G-iqj0u03iv2w6uvUuvrmFX1PJMSHAdQ@mail.gmail.com
Whole thread Raw
In response to Re: copy expensive local view to an RDS instance  (Marcus Engene <mengpg2@engene.se>)
Responses Re: copy expensive local view to an RDS instance
List pgsql-general
Tree view
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 by date:

Previous
From: Marcus Engene
Date:
Subject: Re: copy expensive local view to an RDS instance
Next
From: Marcus Engene
Date:
Subject: Re: copy expensive local view to an RDS instance