Content-Type: text/plain; charset=us-ascii
Mime-Version: 1.0 (Apple Message framework v1082)
Subject: Re: Hot-standby/Reporting database.
From: jonathan ferguson <jdpf@hoozinga.com>
In-Reply-To: <AANLkTim5p3XBZ1p6OojZuRqBi4mcZdLcRqWsHtKKAyGd@mail.gmail.com>
Date: Sun, 20 Mar 2011 23:38:25 -0400
Content-Transfer-Encoding: quoted-printable
Message-Id: <AFB797B0-58B7-4229-8936-7AD96D77DC24@hoozinga.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>
To: pgsql-admin@postgresql.org

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,
>>=20
>> you can use the contrib module dblink for this:
>> http://www.postgresql.org/docs/9.0/static/dblink.html
>=20
> 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.=20

Please explain.

Thanks.

have a day.yad
jdpf