Re: Poatgresql database on more than one disk

From: Jim Rosenberg <jr(at)amanue(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Poatgresql database on more than one disk
Date: 2004-05-31 23:00:41
Message-ID: 42243121.1086030041@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

--On Monday, May 31, 2004 2:14 PM -0500 "Philip A. Chapman"
<pchapman(at)pcsw(dot)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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gaetano Mendola 2004-05-31 23:50:19 Re: Insert speed question
Previous Message Martijn van Oosterhout 2004-05-31 22:10:03 Re: statement level triggers in PostgreSQL , anybody??