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

help / color / mirror / Atom feed
From: jonathan ferguson <jdpf@hoozinga.com>
To: pgsql-admin@postgresql.org
Subject: Re: Hot-standby/Reporting database.
Date: Sun, 20 Mar 2011 23:38:25 -0400
Message-ID: <AFB797B0-58B7-4229-8936-7AD96D77DC24@hoozinga.com> (raw)
In-Reply-To: <AANLkTim5p3XBZ1p6OojZuRqBi4mcZdLcRqWsHtKKAyGd@mail.gmail.com>
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>
	<AANLkTimncdVff7uwgEdC4GJDDDPa706N4MD0kE7yeQJ2@mail.gmail.com>
	<AANLkTim5p3XBZ1p6OojZuRqBi4mcZdLcRqWsHtKKAyGd@mail.gmail.com>

hi.

On Mar 20, 2011, at 9:05 PM, Jaime Casanova wrote:

> 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

Perhaps I'm in the clueless n00b category, here, but how does:

"dblink [] a module which supports connections to other PostgreSQL databases from within a database session."

Even approach solving the problem of Database Replication for Data Warehousing aka Reports DB?

dblink looks more like SSH or Telnet for DB access than a db replication solution to me. 

Please explain.

Thanks.

have a day.yad
jdpf




view thread (7+ messages)  latest in thread

Message-ID: <AFB797B0-58B7-4229-8936-7AD96D77DC24@hoozinga.com>
Permalink:  ../AFB797B0-58B7-4229-8936-7AD96D77DC24@hoozinga.com/
Also on:    postgresql.org/message-id/AFB797B0-58B7-4229-8936-7AD96D77DC24@hoozinga.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: jdpf@hoozinga.com
  Subject: Re: Hot-standby/Reporting database.
  In-Reply-To: <AFB797B0-58B7-4229-8936-7AD96D77DC24@hoozinga.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