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

Re: register/unregister standby Re: Synchronous replication

From: Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
To: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
Cc: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, Joshua Tolley <eggyknap(at)gmail(dot)com>, Yeb Havinga <yebhavinga(at)gmail(dot)com>, Aidan Van Dyk <aidan(at)highrise(dot)ca>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: register/unregister standby Re: Synchronous replication
Date: 2010-09-02 09:41:51
Message-ID: 87y6bkxz1c.fsf@hi-media-techno.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com> writes:
> Hmm, that's clever. I was thinking that you'd initialize the standby from an
> existing backup, and in that context the standby would not need to connect
> to the master except via the replication connection. To take a base backup,
> you'll need not only that but also access to the filesystem in the master,
> ie. shell access.

In fact you don't need shell access here, it's rather easy to stream the
base backup from the libpq connection, as implemented here :

  http://github.com/dimitri/pg_basebackup

> There's been some talk of being able to stream a base backup over the
> replication connection too, which would be extremely handy. 

Yes please ! :)
-- 
dim

In response to

Responses

pgsql-hackers by date

Next:From: Dimitri FontaineDate: 2010-09-02 09:47:14
Subject: Re: array_agg() NULL Handling
Previous:From: Magnus HaganderDate: 2010-09-02 08:01:09
Subject: Re: git: uh-oh

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