Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id F191D9FB2E6 for ; Wed, 24 Jan 2007 11:39:48 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 47649-03 for ; Wed, 24 Jan 2007 11:39:37 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by postgresql.org (Postfix) with ESMTP id B94A99F9FE2 for ; Wed, 24 Jan 2007 11:39:37 -0400 (AST) Received: from list by ciao.gmane.org with local (Exim 4.43) id 1H9kDV-0003nA-8b for pgsql-admin@postgresql.org; Wed, 24 Jan 2007 16:39:17 +0100 Received: from pirus.securax.be ([213.16.46.130]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 24 Jan 2007 16:39:17 +0100 Received: from milen by pirus.securax.be with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 24 Jan 2007 16:39:17 +0100 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-admin@postgresql.org From: "Milen A. Radev" Subject: Re: Postgresql Upgrade 7.4 to 8.2 Date: Wed, 24 Jan 2007 17:39:10 +0200 Lines: 16 Message-ID: <45B77D9E.4080409@radev.net> References: <21058.63.118.86.10.1169649336.squirrel@www.88thstreet.com> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Complaints-To: usenet@sea.gmane.org Cc: pgsql-admin@postgresql.org X-Gmane-NNTP-Posting-Host: pirus.securax.be User-Agent: Mozilla Thunderbird 1.5.0.9 (Windows/20061207) In-Reply-To: <21058.63.118.86.10.1169649336.squirrel@www.88thstreet.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/227 X-Sequence-Number: 24383 Radhika Sambamurti написа: [...] > Some general questions I have are: > 1. How is the backup and recovery using WAL logging in 8.2 > Currently we use Slony for replication, but have no PITR / backup in > place, which makes me very nervous. [...] Also these: http://www.postgresql.org/docs/8.2/static/continuous-archiving.html http://www.postgresql.org/docs/8.2/static/warm-standby.html -- Milen A. Radev