Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZAhYc-00046t-9j for pgsql-admin@arkaria.postgresql.org; Thu, 02 Jul 2015 16:41:50 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZAhYb-00073u-7M for pgsql-admin@arkaria.postgresql.org; Thu, 02 Jul 2015 16:41:49 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZAhWH-0005BE-D8 for pgsql-admin@postgresql.org; Thu, 02 Jul 2015 16:39:25 +0000 Received: from omr1.cc.ipv6.vt.edu ([2607:b400:92:8300:0:c6:2117:b0e] helo=omr1.cc.vt.edu) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZAhW9-0004Ab-2x for pgsql-admin@postgresql.org; Thu, 02 Jul 2015 16:39:24 +0000 Received: from mr5.cc.vt.edu (mr5.cc.ipv6.vt.edu [IPv6:2001:468:c80:2105:0:2b8:b328:9234]) by omr1.cc.vt.edu (8.14.4/8.14.4) with ESMTP id t62GdD4Q011554 for ; Thu, 2 Jul 2015 12:39:13 -0400 Received: from mail-qg0-f53.google.com (mail-qg0-f53.google.com [209.85.192.53]) by mr5.cc.vt.edu (8.14.4/8.14.4) with ESMTP id t62Gd8hv026399 for ; Thu, 2 Jul 2015 12:39:13 -0400 Received: by qgii30 with SMTP id i30so35470329qgi.1 for ; Thu, 02 Jul 2015 09:39:08 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:message-id:date:from:user-agent:mime-version:to :subject:content-type:content-transfer-encoding; bh=8k4ZywyQ1TgKjvkXBM8DVChiAAKdJnAK/KMmRJazpQk=; b=OVztoEm5GBaHqWdGfhqmkNFFnlnC4XqhzsrelXumkcU1ZJaugR8v5RnqIH6bEQl3Mz jGdyLyHhZWLzAvvu7XS+BJtHLmGv0SM+D0EV8zkdwl26VMlzzATvu4XI7dlynOIpbzBT Jqy/k3S9yfZH+npk4uk3VzPqfS1/7N0cuXiaRQ/PNudQhCXp5rZ2i9dUIuTVOspjcOEJ hU1BEyf40++EexLlOtP5iGD4xHrw4KpcUbdrMv0b/9ltVr+/jEIbjQj3IJINR/QFHWTC siCZ96iZte9qTK1QBtTnXVVsGwPMcLkKzzpSONvMwCBVHeLAeFlg61aEp4vDFPrrRZ3w Af3Q== X-Gm-Message-State: ALoCoQnJvFPpSoE30lTE9bv8LHoQAxHVjMCAX00owttkBksg481KGGtu0xSqq1aOZ1gye5Gory5unIOrrED5qMRfej9Pc7s2LyU5x00ShwSybVpBEG9v2gvonjUHHbHJxCKmSiIIE+VjHpPbVxfgmnPHjeN4Q7U9KvthpF6NRhk51C9dt1KR80BpNC4Xg7eebdhAf8WnKNaE X-Received: by 10.140.108.6 with SMTP id i6mr43252049qgf.73.1435855148384; Thu, 02 Jul 2015 09:39:08 -0700 (PDT) X-Received: by 10.140.108.6 with SMTP id i6mr43252033qgf.73.1435855148286; Thu, 02 Jul 2015 09:39:08 -0700 (PDT) Received: from stell.cns.vt.edu (stell.cns.vt.edu. [128.173.8.158]) by mx.google.com with ESMTPSA id e10sm2991637qka.40.2015.07.02.09.39.07 for (version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Thu, 02 Jul 2015 09:39:07 -0700 (PDT) Message-ID: <5595692B.1010602@vt.edu> Date: Thu, 02 Jul 2015 12:39:07 -0400 From: Ray Stell User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:31.0) Gecko/20100101 Thunderbird/31.7.0 MIME-Version: 1.0 To: "pgsql-admin@postgresql.org" Subject: pg_basebackup state? Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit X-Spam-Status: No, score=-0.7 required=5.0 tests=RCVD_IN_DNSWL_LOW autolearn=disabled version=3.3.1 X-Spam-Checker-Version: SpamAssassin 3.3.1 (2010-03-16) on mr5.cc.vt.edu X-Pg-Spam-Score: -2.5 (--) 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 I need help determining the state of the pg_basebackup command. This works command works on other hosts and I make a connection as recorded in the postmaster log: 2015-07-02 12:10:53 EDT,0,authentication LOG: replication connection authorized: user=rep the process is running: > ps -ef | grep pg_base pg 32600 11558 0 12:10 pts/1 00:00:00 pg_basebackup -D basebackup/ --xlog --format=t -P -U rep pg 32601 1473 0 12:10 ? 00:00:00 postgres: wal sender process rep [local] sending backup "pg_basebackup base backup" but no data is written. Looks like wal sender is hurt. max_wal_senders = 3, I wonder if this is the reason for the stall. How to eval if this is set to low? Thanks. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin