Re: Hot-standby/Reporting database.

Поиск
Список
Период
Сортировка
От Jaime Casanova
Тема Re: Hot-standby/Reporting database.
Дата
Msg-id AANLkTim5p3XBZ1p6OojZuRqBi4mcZdLcRqWsHtKKAyGd@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Hot-standby/Reporting database.  (Jaime Casanova <jaime@2ndquadrant.com>)
Ответы Re: Hot-standby/Reporting database.
Список pgsql-admin
On Sun, Mar 20, 2011 at 8:04 PM, Jaime Casanova <jaime@2ndquadrant.com> wrote:
> On Fri, Mar 18, 2011 at 4:25 PM, John P Weatherman
> <jweatherman91@alumni.wfu.edu> wrote:
>>
>> Has anyone run into this already and have an idea for a work around?  I
>> am primarily an Oracle guy and in that environment I would set up a
>> second DB with database links to the hot standby,
>
> you can use the contrib module dblink for this:
> http://www.postgresql.org/docs/9.0/static/dblink.html
>

obviously you need to install the module libraries in both the master
and the slave and the sql functions that create objects in master only

--
Jaime Casanova         www.2ndQuadrant.com
Professional PostgreSQL: Soporte y capacitación de PostgreSQL

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

Предыдущее
От: Jaime Casanova
Дата:
Сообщение: Re: Hot-standby/Reporting database.
Следующее
От: jonathan ferguson
Дата:
Сообщение: Re: Hot-standby/Reporting database.