From: CS DBA <cs_dba@consistentstate.com>
To: Prashanth Ranjalkar <prashant.ranjalkar@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: HOT Standby - slave does not appear to be removing wal files
Date: Wed, 06 Mar 2013 19:09:43 -0700
Message-ID: <5137F6E7.2000300@consistentstate.com> (raw)
In-Reply-To: <CAMBytETi_gNZfY441CDhdqvB0kF_AGVAL2Rn76adNGcZaZXniA@mail.gmail.com>
References: <5137EE26.6010405@consistentstate.com>
<CAMBytETi_gNZfY441CDhdqvB0kF_AGVAL2Rn76adNGcZaZXniA@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
On 3/6/13 7:02 PM, Prashanth Ranjalkar wrote:
> While setting up Hot Standby, it's not a method to copy the primary
> database using dump and restore it on standby using restore command
> as it's a logical backup. I doubt your WAL archiving is enabled and
> files are copied to archive destination that set in archive_command
> therefore keep accumulating under pg_xlog directory.
>
> For hot standby setup, archiving must be enabled and online backup
> (file system level) needs to be taken for setting up Standby server
> and recovery.conf need to be prepared on slave server.
>
> Please go through
> http://www.postgresql.org/docs/9.2/static/high-availability.htmlfor
> more details.
> /*Thanks & Regards,*/
> //**
> /*Prashanth Ranjalkar*/
> /*Database Consultant & Architect*/
> /*Skype:prashanth.ranjalkar*/
> */www.postgresdba.net <http://www.postgresdba.net/>/*
>
>
>
> On Thu, Mar 7, 2013 at 7:02 AM, CS DBA <cs_dba@consistentstate.com
> <mailto:cs_dba@consistentstate.com>> wrote:
>
> All;
>
> We're doing a migration as follows:
>
> 1) we setup a HOT standby pair
>
> 2) we did an import of a db that wan backed up via pg_dump
>
> The pg_xlog directory has > 1700 files in it, It seems that the
> slave is way behind which I get since we just imported a 55GB
> database but the slave is not removing it's local pg_xlog wal files.
>
> We actually stopped the import when the slave hit 97% full for
> the file system where we have it's pg_xlog directory mounted
> after like 30minutes the file count in the slave's pg_xlog dir has
> not changed.
>
> Any thoughts per why the slave is not removing these files?
>
> Thanks in advance
>
>
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org
> <mailto:pgsql-admin@postgresql.org>)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
>
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
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: cs_dba@consistentstate.com, prashant.ranjalkar@gmail.com
Subject: Re: HOT Standby - slave does not appear to be removing wal files
In-Reply-To: <5137F6E7.2000300@consistentstate.com>
* 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