Re: copy expensive local view to an RDS instance

Поиск
Список
Период
Сортировка
От bricklen
Тема Re: copy expensive local view to an RDS instance
Дата
Msg-id CAGrpgQ9QYxOgSVN-OWagdoUNGdwDXTpTg4qd5D=dCPgqficVYw@mail.gmail.com
обсуждение исходный текст
Ответ на copy expensive local view to an RDS instance  (Marcus Engene <mengpg2@engene.se>)
Ответы Re: copy expensive local view to an RDS instance
Список pgsql-general
On Tue, May 6, 2014 at 5:52 AM, Marcus Engene <mengpg2@engene.se> 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

How would you go about doing this?

Thanks,
Marcus

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

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Server process crash - Segmentation fault
Следующее
От: Marcus Engene
Дата:
Сообщение: Re: copy expensive local view to an RDS instance