pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Jaime Casanova <jaime@2ndquadrant.com>
To: jweatherman91@alumni.wfu.edu
Cc: pgsql-admin@postgresql.org
Subject: Re: Hot-standby/Reporting database.
Date: Sun, 20 Mar 2011 20:04:01 -0500
Message-ID: <AANLkTimncdVff7uwgEdC4GJDDDPa706N4MD0kE7yeQJ2@mail.gmail.com> (raw)
In-Reply-To: <1300483544.6860.48.camel@darkflame.weatherman.net>
References: <0515F2BB-0522-449C-848B-4E750F4D91BB@pandora.com>
	<AANLkTimA6_Ai_pd2fmg5OHQYhiG8-4WAKXpBeA_3Muvv@mail.gmail.com>
	<A71C2574-38E9-4EC4-A118-20E11546B7C8@pandora.com>
	<1300483544.6860.48.camel@darkflame.weatherman.net>

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



view thread (7+ messages)  latest in thread

Message-ID: <AANLkTimncdVff7uwgEdC4GJDDDPa706N4MD0kE7yeQJ2@mail.gmail.com>
Permalink:  ../AANLkTimncdVff7uwgEdC4GJDDDPa706N4MD0kE7yeQJ2@mail.gmail.com/
Also on:    postgresql.org/message-id/AANLkTimncdVff7uwgEdC4GJDDDPa706N4MD0kE7yeQJ2@mail.gmail.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: jaime@2ndquadrant.com, jweatherman91@alumni.wfu.edu
  Subject: Re: Hot-standby/Reporting database.
  In-Reply-To: <AANLkTimncdVff7uwgEdC4GJDDDPa706N4MD0kE7yeQJ2@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox