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: (view raw, whole thread or download thread mbox)
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.




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-2017 The PostgreSQL Global Development Group