From: Nestor A. Diaz <nestor@tiendalinux.com>
To: chiru r <chirupg@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Help with PITR in PostgreSQL 8.4
Date: Wed, 17 Jul 2013 10:44:54 -0500
Message-ID: <51E6BBF6.2000000@tiendalinux.com> (raw)
In-Reply-To: <CA+RSxMj79BMdEwtT0CC6-BDKxH1TbccVJZ3sJ_OVTG1oDGqFtg@mail.gmail.com>
References: <51E4725C.3050609@tiendalinux.com>
<CA+RSxMj79BMdEwtT0CC6-BDKxH1TbccVJZ3sJ_OVTG1oDGqFtg@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
On 07/17/2013 03:05 AM, chiru r wrote:
> Hi Nestor,
>
> So the question is: Can I have some continues wal archiving and then
> transfer all WAL files to *standby* everyday, recover the database and
> backup all data without having to rsync the data every time i make a
> backup ?
>
> Yes,You can do as you mentioned.
>
> 1) set the below parameters in Postgresql.conf file on Primary server.
>
> archive_mode=on
> archive_command='cp %p /opt/backup/wal_archives/%f'
>
> 2)apply these wall files to standby server hourly/daily basis as your
> requirement.
> configure the recovery.conf file.
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
Slds.
>
> Best Regards,
> Chiru
>
--
Typed on my key64.org keyboard
Nestor A Diaz
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: nestor@tiendalinux.com, chirupg@gmail.com
Subject: Re: Help with PITR in PostgreSQL 8.4
In-Reply-To: <51E6BBF6.2000000@tiendalinux.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox