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 по дате отправления: