Re: [GENERAL] copy expensive local view to an RDS instance

2014-05-06 Thread Paul Jungwirth
>> 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,

Re: [GENERAL] copy expensive local view to an RDS instance

2014-05-06 Thread Marcus Engene
On 06/05/14 17:15, bricklen wrote: On Tue, May 6, 2014 at 8:07 AM, Marcus Engene > 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/AmazonR

Re: [GENERAL] copy expensive local view to an RDS instance

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

Re: [GENERAL] copy expensive local view to an RDS instance

2014-05-06 Thread Marcus Engene
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

Re: [GENERAL] copy expensive local view to an RDS instance

2014-05-06 Thread bricklen
On Tue, May 6, 2014 at 5:52 AM, Marcus Engene wrote: > Hi, > > I have a local db behind a firewall etc. Basically, I'd like to do what > I'd locally would... > > create table abc > as > select > * > from > local_expensive_view; > > abc - on RDS > local_expensive_view - on local machine >