X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id B1AD09DC83E for ; Fri, 23 Dec 2005 13:53:45 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 11156-03 for ; Fri, 23 Dec 2005 13:53:44 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from ns.snowman.net (ns.snowman.net [66.92.160.21]) by postgresql.org (Postfix) with ESMTP id 1DC0A9DCC88 for ; Fri, 23 Dec 2005 13:53:43 -0400 (AST) Received: by ns.snowman.net (Postfix, from userid 1000) id A7F5E17B6D; Fri, 23 Dec 2005 12:54:30 -0500 (EST) Date: Fri, 23 Dec 2005 12:54:30 -0500 From: Stephen Frost To: Simon Riggs Cc: Tom Lane , Mike C , pgsql-admin@postgresql.org Subject: Re: WAL and pg_dump Message-ID: <20051223175430.GI6026@ns.snowman.net> Mail-Followup-To: Simon Riggs , Tom Lane , Mike C , pgsql-admin@postgresql.org References: <1135208028.2964.329.camel@localhost.localdomain> <1135289852.2964.542.camel@localhost.localdomain> <20051223015001.GD6026@ns.snowman.net> <15885.1135312837@sss.pgh.pa.us> <20051223134347.GE6026@ns.snowman.net> <1135354928.2964.617.camel@localhost.localdomain> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="J46nU19tk8kBC7jb" Content-Disposition: inline In-Reply-To: <1135354928.2964.617.camel@localhost.localdomain> X-Editor: Vim http://www.vim.org/ X-Info: http://www.snowman.net X-Operating-System: Linux/2.4.24ns.3.0 (i686) X-Uptime: 12:47:35 up 195 days, 9:59, 11 users, load average: 0.06, 0.07, 0.02 User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.098 required=5 tests=[AWL=0.098] X-Spam-Score: 0.098 X-Spam-Level: X-Archive-Number: 200512/302 X-Sequence-Number: 20022 --J46nU19tk8kBC7jb Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable * Simon Riggs (simon@2ndquadrant.com) wrote: > On Fri, 2005-12-23 at 08:43 -0500, Stephen Frost wrote: > > Of course, I can also do snapshots with the SAN, but that's a > > one-time thing unlike PITR where you can choose any point in time to > > recover to. >=20 > Why not use SAN Snapshots *and* PITR? They play nicely. Yeah, that's something we're working towards actually. I havn't played with the command-line client quite enough yet to be comfortable sticking it in a script to do the snapshotting. We also don't have everything on the SAN (some things can't be due to different security requirements and some paranoia) so we're making sure that what we're doing will work for those systems as well. Once I'm happier with the SAN command-line client I might substitute that in for the tar generation we're doing now for those databases on the SAN. Thanks, Stephen --J46nU19tk8kBC7jb Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2 (GNU/Linux) iD8DBQFDrDnWrzgMPqB3kigRAvynAJ9l19cVC2lZqxtdUX1YU4Uk+HfhYQCfbtbP HFWRTfhDWR3mxztvxpvEMJM= =/3pz -----END PGP SIGNATURE----- --J46nU19tk8kBC7jb--