Re: pg_standby and compressed archive

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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
-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux