Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UzUm9-00078n-SA for pgsql-admin@arkaria.postgresql.org; Wed, 17 Jul 2013 16:40:26 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1UzUm9-0007Q6-8X for pgsql-admin@arkaria.postgresql.org; Wed, 17 Jul 2013 16:40:25 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UzUm8-0007Pz-6Y for pgsql-admin@postgresql.org; Wed, 17 Jul 2013 16:40:24 +0000 Received: from beast.tiendalinux.com ([65.99.217.191]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UzUm4-0007gJ-9g for pgsql-admin@postgresql.org; Wed, 17 Jul 2013 16:40:23 +0000 Received: from localhost (localhost [127.0.0.1]) by beast.tiendalinux.com (Postfix) with ESMTP id 963CC69C14; Wed, 17 Jul 2013 11:29:05 -0500 (COT) X-Virus-Scanned: Debian amavisd-new at beast.tiendalinux.com Received: from beast.tiendalinux.com ([127.0.0.1]) by localhost (beast.tiendalinux.com [127.0.0.1]) (amavisd-new, port 10024) with LMTP id vmsvHQB1p94t; Wed, 17 Jul 2013 11:29:05 -0500 (COT) X-SMTP-Auth: no X-SMTP-Auth: no Received: from asterix.bog.tiendalinux.com (unknown [190.26.96.114]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client CN "asterix.tiendalinux.com", Issuer "CA Cert Signing Authority" (not verified)) by beast.tiendalinux.com (Postfix) with ESMTPS id 579A069C03; Wed, 17 Jul 2013 11:29:05 -0500 (COT) Received: from localhost (localhost [127.0.0.1]) by asterix.bog.tiendalinux.com (Postfix) with ESMTP id A4C6E211; Wed, 17 Jul 2013 11:40:14 -0500 (COT) X-Virus-Scanned: Debian amavisd-new at bog.tiendalinux.com Received: from asterix.bog.tiendalinux.com ([127.0.0.1]) by localhost (asterix.bog.tiendalinux.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id grg5AV5IqO5o; Wed, 17 Jul 2013 11:40:11 -0500 (COT) Received: from [172.24.107.59] (unknown [172.24.107.59]) by asterix.bog.tiendalinux.com (Postfix) with ESMTP id 8ED49210; Wed, 17 Jul 2013 11:40:11 -0500 (COT) Message-ID: <51E6C8EB.60308@tiendalinux.com> Date: Wed, 17 Jul 2013 11:40:11 -0500 From: "Nestor A. Diaz" User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:10.0.12) Gecko/20130116 Icedove/10.0.12 MIME-Version: 1.0 To: gilberto.castillo@etecsa.cu CC: pgsql-admin@postgresql.org Subject: Re: Help with PITR in PostgreSQL 8.4 References: <51E4725C.3050609@tiendalinux.com> <51E6BBF6.2000000@tiendalinux.com> <37977.192.168.207.54.1374076491.squirrel@webmail.etecsa.cu> In-Reply-To: <37977.192.168.207.54.1374076491.squirrel@webmail.etecsa.cu> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -2.3 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org > Hello Nestor > > I use its: > > standby_mode = 'on' > primary_conninfo = 'host=X.X.X.X port=5432 user=XXXX password=YYYYYTT' > trigger_file = '/var/pgsql/data/pg_failover_trigger' > restore_command = 'cp /wal/%f /var/lib/postgresql/8.4/main/"%p"' Ok, but those instructions are for 9.1 not for 8.4, I would like to be sure if there is any way to perform countinus archiving then recovery then backup and loop over this every day whithout having to rsync every time I recover the standby database (8.4) Slds -- Typed on my key64.org keyboard Nestor A. Diaz T: +57-1-485-3020,211 M: +57-316-227-3593 nestor@tiendalinux.com www.tiendalinux.com -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin