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

Re: Poatgresql database on more than one disk

From: "Postgresql" <postgresql(at)troygeek(dot)com>
To: "'Gaetano Mendola'" <mendola(at)bigfoot(dot)com>,"'Barry'" <bgraetz(at)bigpond(dot)net(dot)au>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Poatgresql database on more than one disk
Date: 2004-05-31 20:03:08
Message-ID: 20040531200325.548F8D1B27C@svr1.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-general
Could you just use the initlocation tool and specify the 'location'
parameter when creating the database?




-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Gaetano Mendola
Sent: Tuesday, May 25, 2004 8:22 PM
To: Barry; pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Poatgresql database on more than one disk

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



















---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html




In response to

pgsql-general by date

Next:From: Josué MaldonadoDate: 2004-05-31 20:05:13
Subject: Insert speed question
Previous:From: Philip A. ChapmanDate: 2004-05-31 19:14:38
Subject: Re: Poatgresql database on more than one disk

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