pg_standby and compressed archive

From: Joby Joba <jobyjoba59(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: pg_standby and compressed archive
Date: 2011-02-04 14:30:00
Message-ID: AANLkTi=TM5MqSZ8i0TFXWE7Q_KEGf0FirxZv6yoTKv-f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello !

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 ?

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'

Thanks for your help !

Regards,

Joby

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Arnold, Sandra 2011-02-04 19:00:38 Changing default tablespace for specific users -- Is it possible?
Previous Message Lou Picciano 2011-02-04 11:32:09 Re: PostgreSQL 9.0