Skip site navigation (1) Skip section navigation (2)

Re: pg_basebackup and wal streaming

From: Yeb Havinga <yebhavinga(at)gmail(dot)com>
To: Magnus Hagander <magnus(at)hagander(dot)net>
Cc: Dimitri Fontaine <dimitri(at)2ndquadrant(dot)fr>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pg_basebackup and wal streaming
Date: 2011-02-26 19:48:16
Message-ID: 4D695900.4090407@gmail.com (view raw or flat)
Thread:
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(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


In response to

Responses

pgsql-hackers by date

Next:From: Magnus HaganderDate: 2011-02-26 19:59:14
Subject: Re: pg_basebackup and wal streaming
Previous:From: Martijn van OosterhoutDate: 2011-02-26 18:58:20
Subject: Re: WIP: cross column correlation ...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group