Re: Hot-standby/Reporting database.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Sun, Mar 20, 2011 at 8:04 PM, Jaime Casanova <jaime@xxxxxxxxxxxxxxx> wrote:
> On Fri, Mar 18, 2011 at 4:25 PM, John P Weatherman
> <jweatherman91@xxxxxxxxxxxxxx> 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

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

-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux