pg_basebackup streaming issue from standby

From: Thom Brown <thom(at)linux(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: pg_basebackup streaming issue from standby
Date: 2012-03-08 01:36:30
Message-ID: CAA-aLv7jaHGxejGfC10JFLY3EO0qwXBHgtPC3Hcc2mFk1hgP4Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

I've just tried using pg_basebackup to take a backup of a standby with
"-x stream" but it never finishes. This is what I get:

thom(at)swift:~/Development$ pg_basebackup -p 5489 -D data3 -x stream -Pv
xlog start point: 0/6000020
pg_basebackup: starting background WAL receiver
78020/78020 kB (100%), 1/1 tablespace
xlog end point: 0/6F819F8
pg_basebackup: waiting for background process to finish streaming...

pg_stat_replication on the standby looks like this:

thom(at)test=# select * from pg_stat_replication ;
-[ RECORD 1 ]----+------------------------------
pid | 29161
usesysid | 10
usename | thom
application_name | pg_basebackup
client_addr |
client_hostname |
client_port | -1
backend_start | 2012-03-08 01:33:32.799491+00
state | startup
sent_location | 0/0
write_location |
flush_location |
replay_location |
sync_priority | 0
sync_state | async
-[ RECORD 2 ]----+------------------------------
pid | 29162
usesysid | 10
usename | thom
application_name | pg_basebackup
client_addr |
client_hostname |
client_port | -1
backend_start | 2012-03-08 01:33:32.921461+00
state | streaming
sent_location | 0/6F819F8
write_location |
flush_location |
replay_location |
sync_priority | 0
sync_state | async

It gets stuck here and never finishes. This also prevents the standby
from shutting down unless pg_basebackup is terminated. I've attached
the log from the standby in case it's of any use (with
log_min_messages set to debug5).

This is using an unpatched copy of latest Git master.

--
Thom

Attachment Content-Type Size
postgresql-2012-03-08_012605.log text/x-log 18.9 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Fujii Masao 2012-03-08 01:45:22 Re: pg_basebackup streaming issue from standby
Previous Message Ali Ahmed 2012-03-08 01:29:38 Re: Requesting Ideas fro project proposal.