From: Vibhor Kumar <vibhor.aim@gmail.com>
To: Joby Joba <jobyjoba59@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: pg_standby and compressed archive
Date: Sun, 6 Feb 2011 21:04:34 +0900
Message-ID: <B580E4CE-E9CA-4625-9B29-5EB5006B91D8@gmail.com> (raw)
In-Reply-To: <AANLkTi=TM5MqSZ8i0TFXWE7Q_KEGf0FirxZv6yoTKv-f@mail.gmail.com>
References: <AANLkTi=TM5MqSZ8i0TFXWE7Q_KEGf0FirxZv6yoTKv-f@mail.gmail.com>
On Feb 4, 2011, at 11:30 PM, Joby Joba wrote:
> in order to reduce disk space used by postgresql's archived logs I use the following command for the parameter archive_command :
> archive_command = 'gzip -c %p >/u10/pgmi/postgresql/archive/%f.gz'
> I have configured a standby database with the contrib module and pg_stanby. My question is : how to tell pg_standby to work with compressed archive ? First of all, is it possible ?
>
No.
> The command which work when archive aren't compressed is like this :
> recovery_command = 'pg_standby -t /tmp/trigger_standby /u10/pgmi/postgres_standby/archive %f %p %r 2> pg_standby.log'
You have to uncompress the wal files first.
Thanks & Regards,
Vibhor
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: vibhor.aim@gmail.com, jobyjoba59@gmail.com
Subject: Re: pg_standby and compressed archive
In-Reply-To: <B580E4CE-E9CA-4625-9B29-5EB5006B91D8@gmail.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