Re: register/unregister standby Re: Synchronous replication - Mailing list pgsql-hackers

From Dimitri Fontaine
Subject Re: register/unregister standby Re: Synchronous replication
Date
Msg-id 87y6bkxz1c.fsf@hi-media-techno.com
Whole thread Raw
In response to Re: register/unregister standby Re: Synchronous replication  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Responses Re: register/unregister standby Re: Synchronous replication  (Itagaki Takahiro <itagaki.takahiro@gmail.com>)
List pgsql-hackers
Heikki Linnakangas <heikki.linnakangas@enterprisedb.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


pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: git: uh-oh
Next
From: Dimitri Fontaine
Date:
Subject: Re: array_agg() NULL Handling