From: | Jaime Casanova <jaime(at)2ndquadrant(dot)com> |
---|---|
To: | jweatherman91(at)alumni(dot)wfu(dot)edu |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Hot-standby/Reporting database. |
Date: | 2011-03-21 01:05:15 |
Message-ID: | AANLkTim5p3XBZ1p6OojZuRqBi4mcZdLcRqWsHtKKAyGd@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Sun, Mar 20, 2011 at 8:04 PM, Jaime Casanova <jaime(at)2ndquadrant(dot)com> wrote:
> On Fri, Mar 18, 2011 at 4:25 PM, John P Weatherman
> <jweatherman91(at)alumni(dot)wfu(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | jonathan ferguson | 2011-03-21 03:38:25 | Re: Hot-standby/Reporting database. |
Previous Message | Jaime Casanova | 2011-03-21 01:04:01 | Re: Hot-standby/Reporting database. |