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

Re: Poatgresql database on more than one disk

From: bgraetz(at)bigpond(dot)net(dot)au (Barry)
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Poatgresql database on more than one disk
Date: 2004-05-26 06:24:29
Message-ID: b47c24a7.0405252224.3bc9b896@posting.google.com (view raw or flat)
Thread:
Lists: pgsql-general
Gaetano Mendola <mendola(at)bigfoot(dot)com> wrote in message news:<40B3E30C(dot)3020408(at)bigfoot(dot)com>...
> 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 on its own internal 
> > disk.
> > 
> > I would like to be able to use one disk pack for development and the
> > other for end user testing / verification (the tape drive can only backup 
> > one disk pack completely, not both)
> > 
> > I have spent a fair amount of time researching how I can run two
> > databases, one on each disk pack but have not been able to find a
> > solution.
> > 
> > Is it possible to configure Postgresql to have seperate databases
> > on seperate disks ?
> 
> Not easily as will be with the Table Space feature that most probably
> will be present on 7.5
> 
> With 7.3.6 what you can do is move your db and create a link in the
> original place:
> 
> -bash-2.05b$ oid2name
> All databases:
> ---------------------------------
> 17142  = kalman
> 19185  = photodb
> 27895  = empdb
> 1      = template1
> 17141  = template0
> 5776262 = logs
> 
> 
> -bash-2.05b$ pwd
> /var/lib/pgsql/data/base
> 
> -bash-2.05b$ ll
> total 32
> drwx------    2 postgres postgres     4096 Feb  8 15:18 1
> drwx------    2 postgres postgres     4096 Feb  8 03:56 17141
> drwx------    2 postgres postgres     4096 May 25 19:37 17142
> drwx------    2 postgres postgres     8192 Feb  8 15:58 19185
> drwx------    3 postgres postgres     8192 May 16 02:46 27895
> drwx------    2 postgres postgres     4096 May 18 00:06 5776262
> 
> 
> 
> 
> 
> in my case if I want the database kalman to another disk what I have to
> do is: stop the engine, move the directory /var/lib/pgsql/data/base/17142
> to the new location and create the link.
> With the same mechanism you can also place different tables in different
> disks.
> 
> I hope this help you.
> 
> 
> Regards
> Gaetano Mendola

Works like a treat, thank you for your time.

Barry

In response to

Responses

pgsql-general by date

Next:From: Richard HuxtonDate: 2004-05-26 07:26:01
Subject: Re: About table schema
Previous:From: Pavel StehuleDate: 2004-05-26 06:20:43
Subject: planer don't use index. bad plan for where id = x or id in (select ...)

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