Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UDPh7-0006QG-Tk for pgsql-admin@arkaria.postgresql.org; Thu, 07 Mar 2013 01:32:30 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UDPh6-00026Z-SI for pgsql-admin@arkaria.postgresql.org; Thu, 07 Mar 2013 01:32:28 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UDPh5-00026T-RV for pgsql-admin@postgresql.org; Thu, 07 Mar 2013 01:32:27 +0000 Received: from mail-pa0-f43.google.com ([209.85.220.43]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UDPh3-0006tO-SP for pgsql-admin@postgresql.org; Thu, 07 Mar 2013 01:32:26 +0000 Received: by mail-pa0-f43.google.com with SMTP id bh2so21634pad.30 for ; Wed, 06 Mar 2013 17:32:24 -0800 (PST) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=20120113; h=x-received:message-id:date:from:user-agent:mime-version:to:subject :content-type:content-transfer-encoding:x-gm-message-state; bh=SxWNn++i52NSZxf4vTlOXLMy/Z7KphJUZVXaW/BmGRQ=; b=aK5SyeDzJQh9AborSnjH9ObbuZaeWk1nKwcGZI0zCzXXhbyp7wSecLqK3lm8dkiYck UcKHzoe7hA20Q+ZQjYzIOrDFGoTxJffYOXyxy1VC+0b6/jwkNRDH0Pvf564r9ygSKvN6 ruYbDHuGwr1y/o/KHGxl+bKM4tHc660JT8zBLbOSkhccEXjnsMJzHkoSHUAmwKI52jDL ITNn7X5OpUmcyZen+eBLeQ3akfo7aKe5OKWqFt9b/fTv/aQXcZQ7VzCn/NgcyCXc1HSe oR20y/C2p4qj7q2wNIaSiAn6fpq5aGJb+c2vjLxX6Wbu2hqANtCkKzhlQbTZJ1qeN+/L VzUw== X-Received: by 10.66.152.177 with SMTP id uz17mr226589pab.4.1362619944309; Wed, 06 Mar 2013 17:32:24 -0800 (PST) Received: from Kevins-MacBook-Pro.local (S01060014bf81f750.cg.shawcable.net. [174.0.118.21]) by mx.google.com with ESMTPS id ub1sm33597423pbc.5.2013.03.06.17.32.23 (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128); Wed, 06 Mar 2013 17:32:23 -0800 (PST) Message-ID: <5137EE26.6010405@consistentstate.com> Date: Wed, 06 Mar 2013 18:32:22 -0700 From: CS DBA User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.8; rv:17.0) Gecko/17.0 Thunderbird/17.0 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: HOT Standby - slave does not appear to be removing wal files Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Gm-Message-State: ALoCoQm1hGCckEA4t6cCad+nVpagfRQ7hP9sUJTHFikf+BSAVNSZpBEwHQYvpI/CxpybKmk+DqqQ X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org 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) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin