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.