Обсуждение: insert data over dblink from bulk select of local table
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. Thanks, Marcus
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.klaver@aklaver.com