On Mon, Apr 09, 2012 at 10:10:34AM -0400, Robert Haas wrote: > On Tue, Mar 13, 2012 at 5:00 AM, <stuart.bis...@canonical.com> wrote: > > The following bug has been logged on the website: > > > > Bug reference: 6528 > > Logged by: Stuart Bishop > > Email address: stuart.bis...@canonical.com > > 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 <br...@momjian.us> 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 (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs