Re: [GENERAL] Poatgresql database on more than one disk

2004-05-31 Thread Karsten Hilbert
> Pardon me for being dense, but I don't see how, with this approach, you > maintain transaction integrity between the two databases. Suppose you need > a transaction involving tables from both databases. Can you explain how you > achieve this? You can't anyways (server side) no matter where th

Re: [GENERAL] Poatgresql database on more than one disk

2004-05-31 Thread Jim Rosenberg
--On Monday, May 31, 2004 2:14 PM -0500 "Philip A. Chapman" <[EMAIL PROTECTED]> wrote: On Tue, 2004-05-25 at 18:33, Barry wrote: Is it possible to configure Postgresql to have seperate databases on seperate disks ? One solution is to run two postmasters (two services). Each would use a differen

Re: [GENERAL] Poatgresql database on more than one disk

2004-05-25 Thread Gaetano Mendola
Barry wrote: Hi All, I am a newcommer to Postgresql, currently I am looking at moving a Pick based application across to PostgreSQL. I am using RH Linux and Postgresql 7.3.6 The test system I am using has a 2 channel raid card with a disk pack connected to each channel. The OS and Postgresql sits o