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

From Jaime Casanova
Subject Re: Hot-standby/Reporting database.
Date
Msg-id AANLkTimOoG9uHAiDXPXLUtPC+WUoMX2d+Bg75yNQqGpf@mail.gmail.com
Whole thread Raw
In response to Re: Hot-standby/Reporting database.  (jonathan ferguson <jdpf@hoozinga.com>)
List pgsql-admin
On Sun, Mar 20, 2011 at 10:38 PM, jonathan ferguson <jdpf@hoozinga.com> wrote:
> 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."
>

your question had 2 parts...
> 1) real time data replication (which the hot standby does) and

for this one hot standby is almost that. ok, you have a little delay
but is that delay that bad that you can't use it?
if it is, 9.1 will ship with synchronous replication

> 2) the ability to create temporary tables as part of their reporting jobs
> (which is expressly prohibited in a hot standby.

AFAIU, the links you say you create in Oracle are for this... no?
that's why i suggest using dblink...
if i misunderstood how you use the database links, please explain...

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

pgsql-admin by date:

Previous
From: "Nicholson, Brad (Toronto, ON, CA)"
Date:
Subject: Re: Memory limits and PostgreSQL 8.4 - Over 63 GB of memory for DB?
Next
From: Vibhor Kumar
Date:
Subject: Re: Hot-standby/Reporting database.