Re: pg_basebackup and wal streaming
Yeb Havinga <yebhavinga@gmail.com>
From: Yeb Havinga <yebhavinga@gmail.com>
To: Magnus Hagander <magnus@hagander.net>
Cc: Dimitri Fontaine <dimitri@2ndquadrant.fr>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2011-02-26T19:48:16Z
Lists: pgsql-hackers
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@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@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