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

Moving postgres to FC disks

From: "Anjan Dave" <adave(at)vantage(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Moving postgres to FC disks
Date: 2004-04-20 20:20:36
Message-ID: 4BAFBB6B9CC46F41B2AD7D9F4BBAF78509814D@vt-pe2550-001.vantage.vantage.com (view raw or flat)
Thread:
Lists: pgsql-performance
I am planning to move the pg databases from the internal RAID to
external Fiber Channel over SAN.

 

Question is - 

 

-With the db size being as big as, say, 30+GB, how do I move it on the
new logical drive? (stop postgresql, and simply move it over somehow and
make a link?)

-Currently, the internal RAID volume is ext3 filesystem. Any
recommendations for the filesystem on the new FC volume? Rieserfs?

 

DBs are 7.4.1(RH9), and 7.2.3 (RH8).

 

 

Appreciate any pointers.

 

Thanks,
Anjan

Responses

pgsql-performance by date

Next:From: Tom LaneDate: 2004-04-20 21:58:31
Subject: Re: Use of subquery causes seq scan???
Previous:From: Paul TuckfieldDate: 2004-04-20 20:02:43
Subject: Re: Wierd context-switching issue on Xeon

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