On Mon, Apr 09, 2012 at 10:10:34AM -0400, Robert Haas wrote:
> On Tue, Mar 13, 2012 at 5:00 AM, <[email protected]> wrote:
> > The following bug has been logged on the website:
> >
> > Bug reference: 6528
> > Logged by: Stuart Bishop
> > Email address: [email protected]
> > PostgreSQL version: 9.1.3
> > Operating system: Ubuntu
> > Description:
> >
> > In section 24.3.5.1 of the docs on setting up continuous archiving, there
> > are a few paragraphs and examples for using pglesslog (pg_compresslog and
> > pg_decompresslog). This tool did not get out of beta for 9.0 and the only
> > reports I find for 9.1 are for not being able to compile it. Suggest
> > removing it from the docs unless someone wants to pull this tool into the
> > core.
>
> This complaint appears to be accurate. I think we should go ahead and
> remove that mention.
Agreed; removed with the attached patch. I didn't bother keeping the
gzip mention because I assume there is little value to using without
pglesslog.
--
Bruce Momjian <[email protected]> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
diff --git a/doc/src/sgml/backup.sgml b/doc/src/sgml/backup.sgml
new file mode 100644
index 4227b66..bd7e42d
*** a/doc/src/sgml/backup.sgml
--- b/doc/src/sgml/backup.sgml
*************** tar -rf /var/lib/pgsql/backup.tar /var/l
*** 1246,1267 ****
Please remember to add error handling to your backup scripts.
</para>
- <para>
- If archive storage size is a concern, use
<application>pg_compresslog</>,
- <ulink url="http://pglesslog.projects.postgresql.org";></ulink>, to
- remove unnecessary <xref linkend="guc-full-page-writes"> and trailing
- space from the WAL files. You can then use
- <application>gzip</application> to further compress the output of
- <application>pg_compresslog</>:
- <programlisting>
- archive_command = 'pg_compresslog %p - | gzip > /var/lib/pgsql/archive/%f'
- </programlisting>
- You will then need to use <application>gunzip</> and
- <application>pg_decompresslog</> during recovery:
- <programlisting>
- restore_command = 'gunzip < /mnt/server/archivedir/%f | pg_decompresslog -
%p'
- </programlisting>
- </para>
</sect3>
<sect3 id="backup-scripts">
--- 1246,1251 ----
--
Sent via pgsql-bugs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
