Re: copy expensive local view to an RDS instance

On 06/05/14 17:15, bricklen wrote:
> On Tue, May 6, 2014 at 8:07 AM, Marcus Engene <mengpg2(at)engene(dot)se
> <mailto: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?
>
>
> 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
Sorry, no, I want to push data from my local machine but I've only seen
examples of push with dblink_exec and litteral values rather than a
subselect or smth.

Best regards,
Marcus