From: | Vibhor Kumar <vibhor(dot)aim(at)gmail(dot)com> |
---|---|
To: | Joby Joba <jobyjoba59(at)gmail(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: pg_standby and compressed archive |
Date: | 2011-02-06 12:04:34 |
Message-ID: | B580E4CE-E9CA-4625-9B29-5EB5006B91D8@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Guy Deleeuw | 2011-02-06 13:15:44 | How to |
Previous Message | Kevin Grittner | 2011-02-04 19:26:02 | Re: Changing default tablespace for specific users -- Is it possible? |