[GENERAL] two postgres server seeing the same data

2008-12-03 Thread Jaime Casanova
Hi, a client of mine is obsessed with the idea of having two postgres servers looking at the same partition of data... i think i can configure two servers pointing to the same $PGDATADIR and let one off and the other on but is it possible for load balancing, i mean with the two servers active?

Re: [GENERAL] two postgres server seeing the same data

2008-12-03 Thread Dave Page
On Wed, Dec 3, 2008 at 5:29 PM, Jaime Casanova [EMAIL PROTECTED] wrote: Hi, a client of mine is obsessed with the idea of having two postgres servers looking at the same partition of data... i think i can configure two servers pointing to the same $PGDATADIR and let one off and the other on

Re: [GENERAL] two postgres server seeing the same data

2008-12-03 Thread Joshua D. Drake
On Wed, 2008-12-03 at 12:29 -0500, Jaime Casanova wrote: Hi, a client of mine is obsessed with the idea of having two postgres servers looking at the same partition of data... i think i can configure two servers pointing to the same $PGDATADIR and let one off and the other on but is it

Re: [GENERAL] two postgres server seeing the same data

2008-12-03 Thread Andrew Sullivan
On Wed, Dec 03, 2008 at 09:43:24AM -0800, Joshua D. Drake wrote: You may have two servers pointed at $PGDATA but at no point can postgresql be running on both at the same time. More importantly, if you do this, you will probably be able to get the two postmasters to start up. This will

Re: [GENERAL] two postgres server seeing the same data

2008-12-03 Thread Jaime Casanova
On Wed, Dec 3, 2008 at 1:10 PM, Andrew Sullivan [EMAIL PROTECTED] wrote: On Wed, Dec 03, 2008 at 09:43:24AM -0800, Joshua D. Drake wrote: You may have two servers pointed at $PGDATA but at no point can postgresql be running on both at the same time. More importantly, if you do this, you will

Re: [GENERAL] two postgres server seeing the same data

2008-12-03 Thread Scott Marlowe
On Wed, Dec 3, 2008 at 2:23 PM, Jaime Casanova [EMAIL PROTECTED] wrote: On Wed, Dec 3, 2008 at 1:10 PM, Andrew Sullivan [EMAIL PROTECTED] wrote: On Wed, Dec 03, 2008 at 09:43:24AM -0800, Joshua D. Drake wrote: You may have two servers pointed at $PGDATA but at no point can postgresql be

Re: [GENERAL] two postgres server seeing the same data

2008-12-03 Thread Scott Marlowe
On Wed, Dec 3, 2008 at 2:29 PM, Scott Marlowe [EMAIL PROTECTED] wrote: On Wed, Dec 3, 2008 at 2:23 PM, Jaime Casanova [EMAIL PROTECTED] wrote: On Wed, Dec 3, 2008 at 1:10 PM, Andrew Sullivan [EMAIL PROTECTED] wrote: On Wed, Dec 03, 2008 at 09:43:24AM -0800, Joshua D. Drake wrote: You may have

Re: [GENERAL] two postgres server seeing the same data

2008-12-03 Thread Joshua D. Drake
On Wed, 2008-12-03 at 16:23 -0500, Jaime Casanova wrote: On Wed, Dec 3, 2008 at 1:10 PM, Andrew Sullivan [EMAIL PROTECTED] wrote: On Wed, Dec 03, 2008 at 09:43:24AM -0800, Joshua D. Drake wrote: You may have two servers pointed at $PGDATA but at no point can postgresql be running on both at

Re: [GENERAL] two postgres server seeing the same data

2008-12-03 Thread Jaime Casanova
On Wed, Dec 3, 2008 at 4:30 PM, Scott Marlowe [EMAIL PROTECTED] wrote: On Wed, Dec 3, 2008 at 2:29 PM, Scott Marlowe [EMAIL PROTECTED] wrote: On Wed, Dec 3, 2008 at 2:23 PM, Jaime Casanova [EMAIL PROTECTED] wrote: On Wed, Dec 3, 2008 at 1:10 PM, Andrew Sullivan [EMAIL PROTECTED] wrote: On

Re: [GENERAL] two postgres server seeing the same data

2008-12-03 Thread Scott Marlowe
On Wed, Dec 3, 2008 at 2:41 PM, Jaime Casanova [EMAIL PROTECTED] wrote: ok... actually i see no real value in that config (create a single point of contention) but everyone that has used (or at least read about) oracle think is the best thing to do... Having dealth with RAC, I can safely say

Re: [GENERAL] two postgres server seeing the same data

2008-12-03 Thread Andrew Sullivan
On Wed, Dec 03, 2008 at 04:23:15PM -0500, Jaime Casanova wrote: is this true even if one of the server just send SELECTs? Yep. A -- Andrew Sullivan [EMAIL PROTECTED] -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: