Re: Poatgresql database on more than one disk - Mailing list pgsql-general

From Jim Rosenberg
Subject Re: Poatgresql database on more than one disk
Date
Msg-id 42243121.1086030041@localhost
Whole thread Raw
In response to Re: Poatgresql database on more than one disk  ("Philip A. Chapman" <pchapman@pcsw.us>)
Responses Re: Poatgresql database on more than one disk  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
List pgsql-general
--On Monday, May 31, 2004 2:14 PM -0500 "Philip A. Chapman"
<pchapman@pcsw.us> 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 value for the PGDATA environment variable.

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?


pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: statement level triggers in PostgreSQL , anybody??
Next
From: Gaetano Mendola
Date:
Subject: Re: Insert speed question