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.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
