Re: pg_basebackup state?

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Ray Stell <stellr(at)vt(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_basebackup state?
Date: 2015-07-02 16:59:24
Message-ID: CAECtzeUMJLY7OUNE+UCZ0oN9O-0C1DY=yaYrebAzrHVdYL48wg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Le 2 juil. 2015 6:41 PM, "Ray Stell" <stellr(at)vt(dot)edu> a écrit :
>
> 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.
>

You wouldn't have the wal sender if it was too low.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ray Stell 2015-07-02 17:01:28 Re: pg_basebackup state?
Previous Message Joshua D. Drake 2015-07-02 16:50:18 Re: pg_basebackup state?