X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id B72629FB2F5 for ; Thu, 3 Aug 2006 23:06:53 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 46510-04 for ; Fri, 4 Aug 2006 02:06:49 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from stash.illumen.com (unknown [64.207.29.137]) by postgresql.org (Postfix) with ESMTP id 556019FB2DD for ; Thu, 3 Aug 2006 23:06:48 -0300 (ADT) Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C6B76A.A3B39F4D" Subject: File system backup question X-MimeOLE: Produced By Microsoft Exchange V6.5 Date: Thu, 3 Aug 2006 20:06:46 -0600 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: File system backup question Thread-Index: Aca3aoBwMhW+NjQHTE6/sioEr3+2TQ== From: "Benjamin Krajmalnik" To: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200608/32 X-Sequence-Number: 22576 This is a multi-part message in MIME format. ------_=_NextPart_001_01C6B76A.A3B39F4D Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable 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). =20 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). =20 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). =20 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. =20 Thanks in advance for any advice. =20 Regards, =20 Benjamin =20 =20 =20 PS. For those who have asked about performance, Windows is much slower than FreeBSD. =20 Machine specs are as follows: =20 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 =20 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. =20 =20 =20 =20 ------_=_NextPart_001_01C6B76A.A3B39F4D Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
I am = currently=20 running PG 8.1.4 windows.
The = system is for a=20 real time monitoring application (so downtime needs to be minimized if = at all=20 possible).
 
I will = be migratng=20 to a new server running PG 8.1.4 on FreeBSD 6.1.
I have = been playing=20 with various options for migrating the data.  The database is = currently=20 about 8.5 GB.
pg_dump took about=20 90 minutes.
pg_restore has been=20 running for over an hour and is abou 4% done (based on row counts on the = tables).
 
I used = the pg_dump=20 option to insert records (as oposed to use the copy command - I don't = know which=20 would be faster for the restore).
 
In any = case, I was=20 thinking about performing a file system backup.
My = concern is that I=20 am movinf between different OS's (although both are i386 = architecture).  I=20 will probably try it tomorrow to see if it works, but was just wondering = if=20 there are any caveats which I should be aware of.
I hope = this works,=20 since for my scenario, this will have the least = downtime.
 
Thanks = in advance=20 for any advice.
 
Regards,
 
Benjamin
 
 
 
PS.  For those=20 who have asked about performance, Windows is much slower than=20 FreeBSD.
 
Machine specs are as=20 follows:
 
Windows 2003 server,=20 HP DL360, SCSI RAID-1, 2GB RAM, 2.8GHz XEON HT
FreeBSD 6.1,=20 SuperMicro 5014C-T, SATA RAID-1, 1GB RAM, P4 3GHz
 
My = stored procedure=20 call went from 47ms avg to 6 ms average execution time on server, = as=20 reported by turning logging on
All = queries in=20 general appeared to run between 5x to 10x faster.
 
 
 
 
------_=_NextPart_001_01C6B76A.A3B39F4D--