Re: Using RSYNC for replication? - Mailing list pgsql-general

From Tom Lane
Subject Re: Using RSYNC for replication?
Date
Msg-id 22704.1043779183@sss.pgh.pa.us
Whole thread Raw
In response to Re: Using RSYNC for replication?  (jhihn1 <jhihn1@umbc.edu>)
Responses Re: Using RSYNC for replication?
Re: Using RSYNC for replication?
List pgsql-general
jhihn1 <jhihn1@umbc.edu> writes:
> I don't understand what is so hard about doing it this way.

If you want separate installations, make separate installations.  Don't
expect multiple databases in a single installation to be implemented
with the same amount of overhead as separate installations would be.
If we did it that way, we'd legitimately get complaints.

> It would make replication so simple and fast.

No it wouldn't; as I've been trying to explain to you, there are a lot
of reasons why rsync'ing a database won't work.  Fixing a few of them
doesn't produce a working solution.  Nor are we going to contort the
system design to make a fundamentally wrongheaded approach to
replication work.  rsync is just not the basis of a workable solution,
because it doesn't and can't know anything about the database state or
the semantics of the different files in the database.

            regards, tom lane

pgsql-general by date:

Previous
From: Arjen van der Meijden
Date:
Subject: Re: Using RSYNC for replication?
Next
From: Will Lowe
Date:
Subject: Re: How do I unsubscribe?