Skip site navigation (1) Skip section navigation (2)

Re: Hot-standby/Reporting database.

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:04:01
Message-ID: AANLkTimncdVff7uwgEdC4GJDDDPa706N4MD0kE7yeQJ2@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
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

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

In response to

Responses

pgsql-admin by date

Next:From: Jaime CasanovaDate: 2011-03-21 01:05:15
Subject: Re: Hot-standby/Reporting database.
Previous:From: jonathan fergusonDate: 2011-03-20 20:54:39
Subject: Re: Hot-standby/Reporting database.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group