Re: [ADMIN] Hot-standby/Reporting database.

2011-03-20 Thread jonathan ferguson
hi. On Mar 18, 2011, at 5:25 PM, John P Weatherman wrote: > All, > > I have recently upgraded to Postgres9 and am building a hot standby for > reporting. Unfortunately, my end users are providing requirements for > 1) real time data replication (which the hot standby does) and 2) the > ability

Re: [ADMIN] Hot-standby/Reporting database.

2011-03-20 Thread Jaime Casanova
On Fri, Mar 18, 2011 at 4:25 PM, John P Weatherman 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

Re: [ADMIN] Hot-standby/Reporting database.

2011-03-20 Thread Jaime Casanova
On Sun, Mar 20, 2011 at 8:04 PM, Jaime Casanova wrote: > On Fri, Mar 18, 2011 at 4:25 PM, John P Weatherman > 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 link

Re: [ADMIN] Hot-standby/Reporting database.

2011-03-20 Thread jonathan ferguson
hi. On Mar 20, 2011, at 9:05 PM, Jaime Casanova wrote: > On Sun, Mar 20, 2011 at 8:04 PM, Jaime Casanova wrote: >> On Fri, Mar 18, 2011 at 4:25 PM, John P Weatherman >> wrote: >>> Has anyone run into this already and have an idea for a work around? I >>> am primarily an Oracle guy and in that