X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id A82BD11F60BE for ; Sat, 29 Apr 2006 10:37:30 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 46266-04 for ; Sat, 29 Apr 2006 10:37:24 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 2930411F60A6 for ; Sat, 29 Apr 2006 10:37:21 -0300 (ADT) Received: from [10.0.0.25] (unknown [64.65.141.234]) (using TLSv1 with cipher RC4-SHA (128/128 bits)) (No client certificate requested) by noel.decibel.org (Postfix) with ESMTP id 4B84D56423; Sat, 29 Apr 2006 08:37:18 -0500 (CDT) In-Reply-To: <20060428153430.B545E11F602A@postgresql.org> References: <20060428153430.B545E11F602A@postgresql.org> Mime-Version: 1.0 (Apple Message framework v749.3) Content-Type: text/plain; charset=WINDOWS-1252; delsp=yes; format=flowed Message-Id: Cc: "'Steve Burrows'" , Content-Transfer-Encoding: quoted-printable From: Jim Nasby Subject: Re: Backing up large databases Date: Fri, 28 Apr 2006 20:30:00 -0500 To: X-Mailer: Apple Mail (2.749.3) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200604/348 X-Sequence-Number: 21517 On Apr 28, 2006, at 10:34 AM, Andy Shellam wrote: > My future plan for when my database grows larger, is with the use =20 > of WAL logging =96 have a base backup taken on a Sunday morning (our =20= > quietest time), ship this to the hot-standby once a week, and start =20= > it off in a recovery mode (using my rolling-WAL script I=92m testing =20= > now.) Then throughout the week, send the WAL logs from the live =20 > box as they become available down to the standby, which then get =20 > processed on arrival =96 these files are 16MB in size (I believe this =20= > can be changed). Theoretically the size of WAL files can be changed, but in practice =20 no one ever does this. In other words, it's probably not a great idea. > This is coming from an 8.1 server, I believe it=92d be okay for 7.4 =20= > but don=92t quote me on it. PITR was introduced in 8.0. There's a number of other reasons to =20 upgrade as well. In the meantime, Slony might be a viable alternative. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461