Re: pg_basebackup and wal streaming

On 2011-02-26 18:19, Magnus Hagander wrote:
> Attached is an updated version of the patch that includes these
> changes, as well as Windows support and an initial cut at a ref page
> for pg_receivexlog (needs some more detail still).
I'm testing a bit more (with the previous version, sorry) and got the
following while doing a stream backup from a cluster that was at that
moment doing a pgbench run with 1 synchronous standby.

mgrid(at)mg79:~$ pg_basebackup --xlog=stream -D /data -vP -h mg73 -U repuser
Password:
xlog start point: 15/720000C8
pg_basebackup: starting background WAL receiver
pg_basebackup: got WAL data offset 14744, expected 16791960424 )
5148915/5148026 kb g(100%) 1/1 tablespaces
xlog end point: 15/80568878
pg_basebackup: waiting for background process to finish streaming...
pg_basebackup: child process exited with error 1

The fetch variant worked ok.

mgrid(at)mg79:~$ pg_basebackup --xlog -D /data -vP -h mg73 -U repuser
Password:
xlog start point: 15/A2000020
5482029/5153458 kb g(100%) 1/1 tablespaces
xlog end point: 15/B51D0230
pg_basebackup: base backup completed.

I'm in total monkey test mode here, so I don't even know if I'm not
supposed to do the streaming variant while other stuff is going on.

regards,
Yeb Havinga