Re: copy expensive local view to an RDS instance

From: bricklen <bricklen(at)gmail(dot)com>
To: Marcus Engene <mengpg2(at)engene(dot)se>
Cc: POSTGRESQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: copy expensive local view to an RDS instance
Date: 2014-05-06 15:15:12
Message-ID: CAGrpgQ8rj-Oy9Rr_z7G-iqj0u03iv2w6uvUuvrmFX1PJMSHAdQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, May 6, 2014 at 8:07 AM, Marcus Engene <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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Paul Jungwirth 2014-05-06 15:30:14 Re: copy expensive local view to an RDS instance
Previous Message Marcus Engene 2014-05-06 15:07:43 Re: copy expensive local view to an RDS instance