Re: Feature request: pg_basebackup --force

On 10.04.2011 20:06, Robert Haas wrote:
> On Sun, Apr 10, 2011 at 12:41 PM, Robert Haas<robertmhaas(at)gmail(dot)com> wrote:
>> Admittedly, the above is a slightly different problem, but I think it
>> all points in the direction of needing more automation and more ease
>> of use.
>
> And let me also note that the difficulty of getting this all exactly
> right is one of the things that causes people to come up with creative
> solutions like this:
>
> http://archives.postgresql.org/pgsql-hackers/2010-12/msg02514.php
>
> That's why we need to put it in a box, tie a bow around it, and put up
> a big sign that says "do not look into laser with remaining eye".

That's exactly what pg_basebackup does. Once you move into more
complicated scenarios with multiple standbys and WAL archiving, it's
inevitably going to be more complicated to set up.

That doesn't mean that we can't make it easier - we can and we should -
but I don't think the common complaint that replication is hard to set
up is true anymore.

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com