Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UzU3V-0004ek-4h for pgsql-admin@arkaria.postgresql.org; Wed, 17 Jul 2013 15:54:17 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1UzU3U-0006Gw-Kw for pgsql-admin@arkaria.postgresql.org; Wed, 17 Jul 2013 15:54:16 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UzU3T-0006Gq-QN for pgsql-admin@postgresql.org; Wed, 17 Jul 2013 15:54:15 +0000 Received: from imx3.etecsa.cu ([200.55.152.137]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UzU3P-0004qE-Al for pgsql-admin@postgresql.org; Wed, 17 Jul 2013 15:54:15 +0000 Received: from Unknown ([192.168.91.45] helo=mn3.etecsa.cu) by imx3.etecsa.cu with ESMTP id rBrXLKHj52391; Wed, 17 Jul 2013 11:53:33 -0500 Received: (qmail 7565 invoked by uid 11185); 17 Jul 2013 16:54:07 -0000 Received: from 192.168.91.6 by mn3.etecsa.cu (envelope-from , uid 502) with qmail-scanner-2.08 (spamassassin: 3.2.5. Clear:RC:1(192.168.91.6):. Processed in 0.056602 secs); 17 Jul 2013 16:54:07 -0000 Received: from unknown (HELO webmail.etecsa.cu) ([192.168.91.6]) (envelope-sender ) by mn2.etecsa.cu (qmail-ldap-1.03) with SMTP for ; 17 Jul 2013 16:54:07 -0000 Received: from 192.168.207.54 (SquirrelMail authenticated user gilberto.castillo) by webmail.etecsa.cu with HTTP; Wed, 17 Jul 2013 10:54:51 -0500 (GMT+5) Message-ID: <37977.192.168.207.54.1374076491.squirrel@webmail.etecsa.cu> In-Reply-To: <51E6BBF6.2000000@tiendalinux.com> References: <51E4725C.3050609@tiendalinux.com> <51E6BBF6.2000000@tiendalinux.com> Date: Wed, 17 Jul 2013 10:54:51 -0500 (GMT+5) Subject: Re: Help with PITR in PostgreSQL 8.4 From: "Gilberto Castillo" To: "Nestor A. Diaz" Cc: "chiru r" , pgsql-admin@postgresql.org Reply-To: gilberto.castillo@etecsa.cu User-Agent: SquirrelMail/1.4.8-5.el5_4.10 MIME-Version: 1.0 X-Priority: 3 (Normal) Importance: Normal X-SpamTest-Envelope-From: gilberto.castillo@etecsa.cu X-SpamTest-Info: Profiles 48678 [Jul 17 2013] X-SpamTest-Method: none X-SpamTest-Rate: 0 X-SpamTest-Status: Not detected X-SpamTest-Status-Extended: not_detected X-SpamTest-Version: SMTP-Filter Version 3.0.0 [0285], KAS30/SDK/Release X-Anti-Virus: Kaspersky Mail Gateway, version: 5.6.28/RELEASE, bases: 20130717T005309 #10611554, check: 20130717 clean Content-Type: multipart/mixed; boundary="=rBrZLiFj55698=imx3.etecsa.cu=" X-Pg-Spam-Score: -0.4 (/) 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 This is a multi-part message in MIME format. --=rBrZLiFj55698=imx3.etecsa.cu= Content-Disposition: inline Content-Type: text/plain;charset=utf-8 Content-Transfer-Encoding: 8bit > Hi Chiru, I have done archiving on primary server, and recovery on > standby server, howerver, after the first recovery I am unable to > recover more wal files on standby server > > Can it be possible in 8.4 ? or just in 9.1 ? > > This is the recovery I use: > > << EOF > > restore_command = '/usr/lib/postgresql/8.4/bin/pg_standby -l -d -s 2 -t > /var/run/postgresql/8.4-main.trigger > /var/lib/postgresql/8.4/main/wal-archive %f %p %r > 2>>/var/log/postgresql/postgresql-8.4-main-standby.log' > recovery_end_command = 'rm -f /var/run/postgresql/8.4-main.trigger' > > EOF > > 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"' Saludos, Gilberto Castillo La Habana, Cuba --=rBrZLiFj55698=imx3.etecsa.cu= Content-Type: text/plain Content-Disposition: inline --- This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE running at host imx3.etecsa.cu Visit our web-site: , --=rBrZLiFj55698=imx3.etecsa.cu= Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 8bit MIME-Version: 1.0 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin --=rBrZLiFj55698=imx3.etecsa.cu=--