Re: Hot-standby/Reporting database. - Mailing list pgsql-admin

From Jaime Casanova
Subject Re: Hot-standby/Reporting database.
Date
Msg-id AANLkTimncdVff7uwgEdC4GJDDDPa706N4MD0kE7yeQJ2@mail.gmail.com
Whole thread Raw
In response to Hot-standby/Reporting database.  (John P Weatherman <jweatherman91@alumni.wfu.edu>)
Responses Re: Hot-standby/Reporting database.  (Jaime Casanova <jaime@2ndquadrant.com>)
List pgsql-admin
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

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

pgsql-admin by date:

Previous
From: jonathan ferguson
Date:
Subject: Re: Hot-standby/Reporting database.
Next
From: Jaime Casanova
Date:
Subject: Re: Hot-standby/Reporting database.