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

Re: Moving postgres to FC disks

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Anjan Dave <adave(at)vantage(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Moving postgres to FC disks
Date: 2004-04-21 00:27:28
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
> -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?)
I would stop the database, move the data directory to the new volume 
using rsync then start up postgresql pointed at the new data directory.
Providing everything is working correctly you can then remove the old 
data directory.

> -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

Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd(at)commandprompt(dot)com -
PostgreSQL Replicator -- production quality replication for PostgreSQL

In response to


pgsql-performance by date

Next:From: Paul TuckfieldDate: 2004-04-21 00:34:13
Subject: Re: Wierd context-switching issue on Xeon
Previous:From: Magnus Naeslund(t)Date: 2004-04-20 22:47:49
Subject: Re: Wierd context-switching issue on Xeon

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