pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedMoving postgres to FC disks
4+ messages / 4 participants
[nested] [flat]
* Moving postgres to FC disks
@ 2004-04-20 20:20 Anjan Dave <adave@vantage.com>
0 siblings, 1 reply; 4+ messages in thread
From: Anjan Dave @ 2004-04-20 20:20 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Moving postgres to FC disks
@ 2004-04-21 00:27 Joshua D. Drake <jd@commandprompt.com>
parent: Anjan Dave <adave@vantage.com>
0 siblings, 2 replies; 4+ messages in thread
From: Joshua D. Drake @ 2004-04-21 00:27 UTC (permalink / raw)
To: Anjan Dave <adave@vantage.com>; +Cc: 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?
>
>
>
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Moving postgres to FC disks
@ 2004-04-21 02:14 Aaron Werman <awerman2@hotmail.com>
parent: Joshua D. Drake <jd@commandprompt.com>
1 sibling, 0 replies; 4+ messages in thread
From: Aaron Werman @ 2004-04-21 02:14 UTC (permalink / raw)
To: Joshua D. Drake <jd@commandprompt.com>; Anjan Dave <adave@vantage.com>; +Cc: pgsql-performance
I agree on not linking and adding non-SAN disk dependancy to your DB. I'm trying to understand your FS reasoning. I have never seen XFS run faster than ReiserFS in any situation (or for that matter beat any FS in performance except JFS). XFS has some nifty very large file features, but we're talking about 30G and all modern FSs support >2G files.
My tendancy would be to stay on ext3, since it is the default RH FS. I would review site preference and the SAN recommended FS and see if they add any compelling points.
/Aaron
----- Original Message -----
From: Joshua D. Drake
To: Anjan Dave
Cc: pgsql-performance@postgresql.org
Sent: Tuesday, April 20, 2004 8:27 PM
Subject: Re: [PERFORM] Moving postgres to FC disks
-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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Moving postgres to FC disks
@ 2004-04-21 21:50 Cott Lang <cott@internetstaff.com>
parent: Joshua D. Drake <jd@commandprompt.com>
1 sibling, 0 replies; 4+ messages in thread
From: Cott Lang @ 2004-04-21 21:50 UTC (permalink / raw)
To: pgsql-performance
On Tue, 2004-04-20 at 17:27, Joshua D. Drake wrote:
> > -Currently, the internal RAID volume is ext3 filesystem. Any
> > recommendations for the filesystem on the new FC volume? Rieserfs?
> >
> >
> XFS
What Linux distributions are popular in here for PG+XFS?
I'm very disappointed that Redhat Enterprise 3 doesn't appear to support
XFS/JFS, or anything else. Suse Server 8 seems very dated, at least from
the eval I downloaded. I'm curious as to where other people have gone
with the death of RH9. I'd have gone on to Redhat 3 if I wasn't
interested in getting some of the benefits of XFS at the same time ...
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2004-04-21 21:50 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-04-20 20:20 Moving postgres to FC disks Anjan Dave <adave@vantage.com>
2004-04-21 00:27 ` Joshua D. Drake <jd@commandprompt.com>
2004-04-21 02:14 ` Aaron Werman <awerman2@hotmail.com>
2004-04-21 21:50 ` Cott Lang <cott@internetstaff.com>
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