Thread: 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