| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dimitri Fontaine | 2010-09-02 09:47:14 | Re: array_agg() NULL Handling |
| Previous Message | Magnus Hagander | 2010-09-02 08:01:09 | Re: git: uh-oh |