Re: Making pg_standby compression-friendly

Charles Duffy wrote:
> I'm interested in compressing archived WAL segments in an environment
> set up for PITR in the interests of reducing both network traffic and
> storage requirements. However, pg_standby presently checks file sizes,
> requiring that an archive segment be exactly the right size to be
> considered valid. The idea of compressing log segments is not new --
> the clearxlogtail project in pgfoundry provides a tool to make such
> compression more effective, and is explicitly intended for said
> purpose -- but as of 8.3.4, pg_standby appears not to support such
> environments; I propose adding such support.

Can't you decompress the files in whatever script you use to copy them
to the archive location?

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com