Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 12E0B133616B for ; Sun, 6 Feb 2011 08:04:51 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 99351-07 for ; Sun, 6 Feb 2011 12:04:44 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-pv0-f174.google.com (mail-pv0-f174.google.com [74.125.83.174]) by mail.postgresql.org (Postfix) with ESMTP id A4D531337B95 for ; Sun, 6 Feb 2011 08:04:43 -0400 (AST) Received: by pva4 with SMTP id 4so716718pva.19 for ; Sun, 06 Feb 2011 04:04:43 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:subject:mime-version:content-type:from :in-reply-to:date:cc:content-transfer-encoding:message-id:references :to:x-mailer; bh=BMFssCAjsW/SdFosYgeshXbD+4miafBQO2H2jN3XtTA=; b=WczeCMrKRE26/Tb5lJuSHSDR5keY21lNxmpWqnmqU/eXlat4oRBdd4wSNandngkDFE omU7OQNWax0CPSi1AmznYBrEoQEaw/c6+HlZP/x07Vk6bWT0VyQ8tLlnatESK9rOc0jT GNRK8MdBcHSk2GzpO0ZqAT/5SsSjzovqjrE90= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=subject:mime-version:content-type:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to:x-mailer; b=DuU4xvlPbATj+3BcgcreAzgxZJlD2yPJR1cCMLG9gHrJGpqb4x8Lgu0tm6mbUGIk6f QeCe02JlvO9eh98MDM6Nn5l7N1IrfReS4BvkG5zXLRNJuzUpYOR/w165nIuiK5s9WWBt 50iED7iA7xoREO9u/X4inPda5JH6km77hZe+8= Received: by 10.142.238.17 with SMTP id l17mr14000601wfh.423.1296993883381; Sun, 06 Feb 2011 04:04:43 -0800 (PST) Received: from [211.177.245.79] ([211.177.245.79]) by mx.google.com with ESMTPS id e14sm4197426wfg.20.2011.02.06.04.04.39 (version=TLSv1/SSLv3 cipher=RC4-MD5); Sun, 06 Feb 2011 04:04:42 -0800 (PST) Subject: Re: pg_standby and compressed archive Mime-Version: 1.0 (Apple Message framework v1082) Content-Type: text/plain; charset=us-ascii From: Vibhor Kumar In-Reply-To: Date: Sun, 6 Feb 2011 21:04:34 +0900 Cc: pgsql-admin@postgresql.org Content-Transfer-Encoding: quoted-printable Message-Id: References: To: Joby Joba X-Mailer: Apple Mail (2.1082) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_LOW=-0.7 X-Spam-Level: X-Archive-Number: 201102/23 X-Sequence-Number: 36662 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 =3D '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 ? >=20 No. > The command which work when archive aren't compressed is like this : > recovery_command =3D '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=