From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Marcus Engene <mengpg2(at)engene(dot)se>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: insert data over dblink from bulk select of local table |
Date: | 2014-03-25 14:52:19 |
Message-ID: | 53319823.4080407@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 03/25/2014 07:22 AM, Marcus Engene wrote:
> Hi,
>
> I have a production database with some heavy views.
>
> I'd like to make a hourly cron (or smth) that bulk inserts new entries
> into a table on RDS.
>
> It's easy to get data down to the prod side, but is it possible to do a
> bulk insert the other way around? All examples I've seen adds the data
> in a litteral way.
AWS restricts server access to the Postgres instance:
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_PostgreSQL.html
"...Amazon RDS does not provide host access to DB instances..."
so I would say COPY is out.
You can use \copy from psql as they demonstrate:
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/PostgreSQL.Procedural.Importing.html
This could be put into a cron job.
>
> Thanks,
> Marcus
>
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2014-03-25 15:01:24 | Re: Upgrading from 9.2 to 9.3 causes performance degradation |
Previous Message | Frank | 2014-03-25 14:49:09 | Please ignore my previous mail: piping pg_dump output / solved |