Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 95391632B8A for ; Thu, 4 Mar 2010 02:47:32 -0400 (AST) 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 95935-08 for ; Thu, 4 Mar 2010 06:47:19 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-fx0-f223.google.com (mail-fx0-f223.google.com [209.85.220.223]) by mail.postgresql.org (Postfix) with ESMTP id 9EE67632AAD for ; Thu, 4 Mar 2010 02:47:21 -0400 (AST) Received: by fxm23 with SMTP id 23so932095fxm.3 for ; Wed, 03 Mar 2010 22:47:20 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:date:message-id:subject :from:to:content-type; bh=OZwvCHT6u7KxNrVbBkkANbQJW/P3BL6AHMQbgxzoiWo=; b=DqhpL2tFm1vf39pF9nW4BA8Zd1bA/zI677w3xgxnVb0UqmGizKaAGBECB+CUcuizWz +OQZ8Ppt7S1KHf5P4a3paBUSKbUf9JKNsnFrM07sA3x+LZ3VpoAZYu4ZC+d69l/BM8Vt 3bZXUMZYtVHRBV9InL/zcQN9leFfiUJFJN3Ic= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=QX3e3DbEc2Lk7tjr/9drCsAVnrC5LZAIQLzJTth5UDLNj7GjpeQWs4Xb2/2rvqtu14 vuJgOujEbqFreLTBYsnpcGDRocer6p/BfnY96+BS1QHc9wvMALH5o+JEUVr5Vwhd+NAs eMAuuWtiJw/iYMcViRXtg1tIEQNIcqxe2Mrd8= MIME-Version: 1.0 Received: by 10.223.95.89 with SMTP id c25mr2428223fan.20.1267685240032; Wed, 03 Mar 2010 22:47:20 -0800 (PST) Date: Thu, 4 Mar 2010 08:47:20 +0200 Message-ID: <2ca799771003032247w2799229dy3381798a723d044f@mail.gmail.com> Subject: Backup from a hot standby From: Mikko Partio To: pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary=0015173fe9d06b4e350480f3f86c X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.598 tagged_above=-10 required=5 tests=BAYES_00=-2.599, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201003/37 X-Sequence-Number: 33836 --0015173fe9d06b4e350480f3f86c Content-Type: text/plain; charset=ISO-8859-1 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 backup from a hot standby, but I guess that is not possible since executing "SELECT pg_start_backup('ss')" returns an error? Or can I just tar $PGDATA and copy the xlog files generated during the backup, since the server is in constant recovery mode? In Oracle it is possible to take backups from a data guard standby, which is very useful since that way making the backups does not stress the master server. Anyway, I must say that we are very pleased to see HS and SR features, and we hope that 9.0.0 goes to beta (and to an official release) soon! Regards Mikko --0015173fe9d06b4e350480f3f86c Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hi

I'm currently testing Pg 9.0.0 alpha 4 and the ho= t standby feature (with streaming replication) is working great. I tried to= take a filesystem backup from a hot standby, but I guess that is not possi= ble since executing "SELECT pg_start_backup('ss')" return= s an error? Or can I just tar $PGDATA and copy the xlog files generated dur= ing the backup, since the server is in constant recovery mode? =A0In Oracle= it is possible to take backups from a data guard standby, which is very us= eful since that way making the backups does not stress the master server.

Anyway, I must say that we are very pleased to see HS a= nd SR features, and we hope that 9.0.0 goes to beta (and to an official rel= ease) soon!

Regards

Mikko=
--0015173fe9d06b4e350480f3f86c--