Message-ID: <51E7EB83.4070508@consistentstate.com>
Date: Thu, 18 Jul 2013 07:20:03 -0600
From: CS DBA <cs_dba@consistentstate.com>
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.8;
 rv:17.0) Gecko/17.0 Thunderbird/17.0
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: Re: Help with PITR in PostgreSQL 8.4
References: <51E4725C.3050609@tiendalinux.com>
 <CA+RSxMj79BMdEwtT0CC6-BDKxH1TbccVJZ3sJ_OVTG1oDGqFtg@mail.gmail.com>
 <51E6BBF6.2000000@tiendalinux.com>
 <37977.192.168.207.54.1374076491.squirrel@webmail.etecsa.cu>
 <51E6C8EB.60308@tiendalinux.com>
In-Reply-To: <51E6C8EB.60308@tiendalinux.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

On 7/17/13 10:40 AM, Nestor A. Diaz wrote:
>> 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
>
>
AFAIK The only way to do this in 8.4 is to make a copy of the standby 
and bring the copy online.  We do it to run backups off the standby like 
this:

1) take the standby down (pg_ctl -m fast stop)
2) rsync the standby to the standby-copy
3) restart the standby (it will return to recovery mode)
4) bring the standby copy online (remove it's recovery.conf and start it up)
5) run the backups on the copy
6) shutdown the copy (but leave it in place so the next rsync only has 
to copy changed data)
7) rinse and repeat


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin