pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Joshua D. Drake <jd@commandprompt.com>
To: Anjan Dave <adave@vantage.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Moving postgres to FC disks
Date: Tue, 20 Apr 2004 17:27:28 -0700
Message-ID: <4085BFF0.4050604@commandprompt.com> (raw)
In-Reply-To: <4BAFBB6B9CC46F41B2AD7D9F4BBAF78509814D@vt-pe2550-001.vantage.vantage.com>
References: <4BAFBB6B9CC46F41B2AD7D9F4BBAF78509814D@vt-pe2550-001.vantage.vantage.com>


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

> 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@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL

view thread (4+ messages)  latest in thread

Message-ID: <4085BFF0.4050604@commandprompt.com>
Permalink:  ../4085BFF0.4050604@commandprompt.com/
Also on:    postgresql.org/message-id/4085BFF0.4050604@commandprompt.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: jd@commandprompt.com, adave@vantage.com
  Subject: Re: Moving postgres to FC disks
  In-Reply-To: <4085BFF0.4050604@commandprompt.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox