Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group