From: Maletin von Oertzen <maletin@cpan.org>
To: pgsql-admin@postgresql.org
Subject: Re: HOT Standby - slave does not appear to be removing wal files
Date: Thu, 23 May 2013 13:02:10 +0000 (UTC)
Message-ID: <loom.20130515T102902-507@post.gmane.org> (raw)
References: <5137EE26.6010405@consistentstate.com>
<CAMBytETi_gNZfY441CDhdqvB0kF_AGVAL2Rn76adNGcZaZXniA@mail.gmail.com>
<5137F6E7.2000300@consistentstate.com>
<20130307111834.5fbda1de419a5f042c13f5b7@yahoo.es>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Eduardo Morras <emorrasg <at> yahoo.es> writes:
>
> On Wed, 06 Mar 2013 19:09:43 -0700
> CS DBA <cs_dba <at> consistentstate.com> wrote:
> > We actually are in HOT standby mode, and it is working. However we are
> > also migrating a second db from an older (8.4) server into this master
> > so we did a dump (using the 9.2.2 pg_dump binary) from the 8.4 db and
> > then restored it into our current 9.2 master
>
> I don't know, but maybe the dump from 8.4 to your master is one big
transaction that must be rolled by the
> slave. So the slave must store all wal files to be able to undo the big
dump transaction.
>
> --- ---
> Eduardo Morras <emorrasg <at> yahoo.es>
>
We have the same problem, when we drop a big schema
and import it again (with \i and autocommit on).
To use pg_basebackup with the option -x, we have
wal_keep_segments set to 32.
And we use pg_archive_cleanup_command:
archive_cleanup_command='/usr/lib/postgresql/9.2/bin/pg_archivecleanup
/var/lib/postgresql/9.2/main/pg_xlog %r'
But we get at least 118 WAL-Files.
In the past, we did not set ssl_renegotiation_limit=0
and the archive_command copied quickly so many
WAL-Files to pg_xlog, that the postgresql-database
stopped with no space left on device /var.
https://bugs.launchpad.net/ubuntu/+source/postgresql-9.1/+bug/1018307
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: maletin@cpan.org
Subject: Re: HOT Standby - slave does not appear to be removing wal files
In-Reply-To: <loom.20130515T102902-507@post.gmane.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox