Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id D214E632798 for ; Mon, 5 Apr 2010 05:34:58 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 36801-10 for ; Mon, 5 Apr 2010 08:34:43 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-gx0-f214.google.com (mail-gx0-f214.google.com [209.85.217.214]) by mail.postgresql.org (Postfix) with ESMTP id 4DB246326AC for ; Mon, 5 Apr 2010 05:34:48 -0300 (ADT) Received: by gxk6 with SMTP id 6so3956466gxk.14 for ; Mon, 05 Apr 2010 01:34:47 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:received:message-id:subject:from:to:cc:content-type :content-transfer-encoding; bh=SaPGuTZOl/lxVQwLrwm+BKRTWXUgbv38Q4e8XTkDUEc=; b=O+el7vDqy+q/GLCb+ZNSF95B8m6Y1XWLVkFfnZrhj4bUO/26bUfyqpTge9xkJicmvd 3tQOuWjIWk8XdR2DqWt7TKxz9KqY2sO639yea+iYUNUYOKBqj8zrByrTAQav6NC5QzMc pN1y80c4/EyWeR+0WE/eg6rYge0CchrNgflWw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type:content-transfer-encoding; b=l0c1v++7dfw+XVeAOOgeX/TyddCHZFt8WOP19zH6Y0m2exD3Wjhwpf85YtVbGKQ2F/ Nwi5q3h0AfY/JQAzcy40+X1p3jPSqRNK15tpeiMeGI+wOSUo1EoIimx8ufUA7go2lKNj vw+Wg1xNXYAs5nEbinR9F+oZwwhiIrW7nOL2E= MIME-Version: 1.0 Received: by 10.100.166.2 with HTTP; Mon, 5 Apr 2010 01:34:47 -0700 (PDT) In-Reply-To: <2ca799771003032247w2799229dy3381798a723d044f@mail.gmail.com> References: <2ca799771003032247w2799229dy3381798a723d044f@mail.gmail.com> Date: Mon, 5 Apr 2010 17:34:47 +0900 Received: by 10.100.245.28 with SMTP id s28mr12804568anh.190.1270456487141; Mon, 05 Apr 2010 01:34:47 -0700 (PDT) Message-ID: Subject: Re: Backup from a hot standby From: Fujii Masao To: mpartio@gmail.com Cc: pgsql-admin@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.085 tagged_above=-10 required=5 tests=AWL=0.514, BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201004/26 X-Sequence-Number: 34120 Sorry for the delay. On Thu, Mar 4, 2010 at 3:47 PM, Mikko Partio wrote: > Hi > I'm currently testing Pg 9.0.0 alpha 4 and the hot standby feature (with > streaming replication) is working great. I tried to take a filesystem bac= kup > from a hot standby, but I guess that is not possible since executing "SEL= ECT > pg_start_backup('ss')" returns an error? Or can I just tar $PGDATA and co= py > the xlog files generated during the backup, since the server is in consta= nt > recovery mode? =A0In Oracle it is possible to take backups from a data gu= ard > standby, which is very useful since that way making the backups does not > stress the master server. You can take a base backup of the standby while it's in progress, without calling pg_start_backup() and pg_stop_backup(). Please see the following document. http://developer.postgresql.org/pgdocs/postgres/backup-incremental-updated.= html Regards, --=20 Fujii Masao NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center