From: | Ray Stell <stellr(at)vt(dot)edu> |
---|---|
To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | pg_basebackup state? |
Date: | 2015-07-02 16:39:07 |
Message-ID: | 5595692B.1010602@vt.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Ray Stell | 2015-07-02 16:44:46 | Re: pg_basebackup state? |
Previous Message | Bert | 2015-07-02 11:22:20 | Architecture setup for multiple dwh databases: multi master, master slave, ... |