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

2004-06-01 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 the

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 different

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