pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pg_standby and compressed archive 2+ messages / 2 participants [nested] [flat]
* pg_standby and compressed archive @ 2011-02-04 14:30 Joby Joba <jobyjoba59@gmail.com> 0 siblings, 1 reply; 2+ messages in thread From: Joby Joba @ 2011-02-04 14:30 UTC (permalink / raw) To: 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: pg_standby and compressed archive @ 2011-02-06 12:04 Vibhor Kumar <vibhor.aim@gmail.com> parent: Joby Joba <jobyjoba59@gmail.com> 0 siblings, 0 replies; 2+ messages in thread From: Vibhor Kumar @ 2011-02-06 12:04 UTC (permalink / raw) To: Joby Joba <jobyjoba59@gmail.com>; +Cc: pgsql-admin 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2011-02-06 12:04 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2011-02-04 14:30 pg_standby and compressed archive Joby Joba <jobyjoba59@gmail.com> 2011-02-06 12:04 ` Vibhor Kumar <vibhor.aim@gmail.com>
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