Re: Making pg_standby compression-friendly - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: Making pg_standby compression-friendly
Date
Msg-id 490591DA.EE98.0025.0@wicourts.gov
Whole thread Raw
In response to Re: Making pg_standby compression-friendly  ("Koichi Suzuki" <koichi.szk@gmail.com>)
List pgsql-hackers
>>> "Koichi Suzuki" <koichi.szk@gmail.com> wrote: 
> As Heikki pointed out, the issue is not to decompress the compressed
> WAL, but also how we can keep archive log still compressed after it
is
> handled by pg_standby.
> 
> I'm afraid pg_standby cannot handle this solely, may need some
support
> by the pg core.   For example, after closing archive log in archive
> recovery, pg_core can call some backend to re-compress the archive
log
> for later use.
Why decompress and re-compress?  We're using simple bash scripts, so I
can't speak to pg_standby; but we just pipe the file through gunzip in
the script called by recovery.conf.  The source file isn't modified --
it stays compressed for archiving.
-Kevin


pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Parsing errors in pg_hba.conf
Next
From: Tom Lane
Date:
Subject: Re: ERRORDATA_STACK_SIZE exceeded (server crash)