From: Benjamin Krajmalnik <kraj@illumen.com>
To: pgsql-admin@postgresql.org
Subject: File system backup question
Date: Thu, 3 Aug 2006 20:06:46 -0600
Message-ID: <BF337097BDD9D849A2F4B818DDB27987252584@stash.stackdump.local> (raw)
I am currently running PG 8.1.4 windows.
The system is for a real time monitoring application (so downtime needs
to be minimized if at all possible).
I will be migratng to a new server running PG 8.1.4 on FreeBSD 6.1.
I have been playing with various options for migrating the data. The
database is currently about 8.5 GB.
pg_dump took about 90 minutes.
pg_restore has been running for over an hour and is abou 4% done (based
on row counts on the tables).
I used the pg_dump option to insert records (as oposed to use the copy
command - I don't know which would be faster for the restore).
In any case, I was thinking about performing a file system backup.
My concern is that I am movinf between different OS's (although both are
i386 architecture). I will probably try it tomorrow to see if it works,
but was just wondering if there are any caveats which I should be aware
of.
I hope this works, since for my scenario, this will have the least
downtime.
Thanks in advance for any advice.
Regards,
Benjamin
PS. For those who have asked about performance, Windows is much slower
than FreeBSD.
Machine specs are as follows:
Windows 2003 server, HP DL360, SCSI RAID-1, 2GB RAM, 2.8GHz XEON HT
FreeBSD 6.1, SuperMicro 5014C-T, SATA RAID-1, 1GB RAM, P4 3GHz
My stored procedure call went from 47ms avg to 6 ms average execution
time on server, as reported by turning logging on
All queries in general appeared to run between 5x to 10x faster.
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: kraj@illumen.com
Subject: Re: File system backup question
In-Reply-To: <BF337097BDD9D849A2F4B818DDB27987252584@stash.stackdump.local>
References: <BF337097BDD9D849A2F4B818DDB27987252584@stash.stackdump.local>
* 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