Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZAhbg-0004M2-JC for pgsql-admin@arkaria.postgresql.org; Thu, 02 Jul 2015 16:45:00 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZAhbg-0007Aa-1r for pgsql-admin@arkaria.postgresql.org; Thu, 02 Jul 2015 16:45:00 +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 1ZAhbe-0007AI-PF for pgsql-admin@postgresql.org; Thu, 02 Jul 2015 16:44:58 +0000 Received: from omr2.cc.ipv6.vt.edu ([2607:b400:92:8400:0:33:fb76:806e] helo=omr2.cc.vt.edu) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZAhba-0004GO-UB for pgsql-admin@postgresql.org; Thu, 02 Jul 2015 16:44:58 +0000 Received: from mr5.cc.vt.edu (mr5.cc.ipv6.vt.edu [IPv6:2001:468:c80:2105:0:2b8:b328:9234]) by omr2.cc.vt.edu (8.14.4/8.14.4) with ESMTP id t62GirAl004974 for ; Thu, 2 Jul 2015 12:44:53 -0400 Received: from mail-qk0-f172.google.com (mail-qk0-f172.google.com [209.85.220.172]) by mr5.cc.vt.edu (8.14.4/8.14.4) with ESMTP id t62Gil1d005539 for ; Thu, 2 Jul 2015 12:44:52 -0400 Received: by qkbp125 with SMTP id p125so55792383qkb.2 for ; Thu, 02 Jul 2015 09:44:47 -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:references:in-reply-to:content-type :content-transfer-encoding; bh=I96NHwTTFVMQu06Pt+mrAv19sNRd8TPU8jB3djQeP1Q=; b=HQIejn2fpFRRZG87zUvl0U1vFW5NcFr/RAe7OQ16Ycxmu5JZaLapjk/XWC2PQqwfGw r5n9PCQoSOFLq0NdSIELPT/MDj2lA5yOLkYv7Vu5vhhuQ+ZFgkjJF0UHoK4pfxrzHxDn wCDm3WVIZV2B+2o667nHVe2VT5dajn5aNOpN1ZMvzzcCtVGRsGQ8g2MASZjBwQ8I1OlU dOlpQW2EzhjIKgW4oKn4rHXI5kSE59zJQuaVurYoKnJ93WHPs4MydTHycCEcQy9Wif6u FxlJSKK6RB6I0KS2a4QZ3i3jtMMz6MXx12EGWp8Ssf21wR5+YyY7h78XSIU1XLih6CUr d6Hw== X-Gm-Message-State: ALoCoQmVT4NLgn5RFccV3MdC3O3KZPlo7CMhY69+pfzoF8Wn4K+SWQ8o/0C5LnXEPlmhQWdG4Q+ZFoegxv3wREnd7WHz9r9kFwbquTvp/QqiQgz3vp6QkzG2fDF9PPacjU1brHvAJnga3XcYj95Dl/yTpLruJT6g+bqsTbUdq5lWtasvNCP+6+h8P6sAbERz/ztk+69EePQ1 X-Received: by 10.140.38.69 with SMTP id s63mr43624503qgs.10.1435855487801; Thu, 02 Jul 2015 09:44:47 -0700 (PDT) X-Received: by 10.140.38.69 with SMTP id s63mr43624485qgs.10.1435855487675; Thu, 02 Jul 2015 09:44:47 -0700 (PDT) Received: from stell.cns.vt.edu (stell.cns.vt.edu. [128.173.8.158]) by mx.google.com with ESMTPSA id 128sm2979695qhg.45.2015.07.02.09.44.47 for (version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Thu, 02 Jul 2015 09:44:47 -0700 (PDT) Message-ID: <55956A7E.3000503@vt.edu> Date: Thu, 02 Jul 2015 12:44:46 -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: Re: pg_basebackup state? References: <5595692B.1010602@vt.edu> In-Reply-To: <5595692B.1010602@vt.edu> 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 On 7/2/15 12:39 PM, Ray Stell wrote: > 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. v 9.4.4, I meant to include. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin