Improve replication usability

From: Andrew Armstrong <phplasma(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Improve replication usability
Date: 2011-12-11 01:58:44
Message-ID: CADxhDSu1esV60zR-2DJpGLFnsm3aiMO2vSwB=QwsK+qyjhKq8w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

First off, thanks for a great product.

I've been looking at setting up replication on Windows between two servers
using pgsql 9.1

I'm going to give up for now though because I'm finding it difficult to get
it working correctly; after copying the \data directory as per the guide at
http://wiki.postgresql.org/wiki/Streaming_Replication the server won't
start anymore - no errors are logged.

It seems to be this problem, but after making sure the postgres user owns
all data files, it still wont start,
http://archives.postgresql.org/pgsql-admin/2010-11/msg00258.php

I'm a software developer and setup mysql/postgresql when needed; but I find
that both of these products are too complicated when it comes to something
like HA/replication.

Can I please suggest the following improvements for a future release?

1) One line setup of replication. Allow me to issue a 'SELECT
pg_replication_connect(remote host)' that will:
a) Perform a backup/download the current database (from scratch) - don't
need me to copy database files
b) Come online and enter a standby state

2) Allow me to easily test failover (issue a SELECT, or just via the
trigger file?)

3) Options like archive_command etc that need to be typed out manually
should be obsolete; let the database server sync itself without needing a
manual file copy.

Basically, I'm suggesting to please remove the administrator overhead for
setting up replication. I appreciate the complexity of such a system, but
it would be fantastic to make it _super trivial_ to get replication working
and online without the possibility of these problems.

Thanks,
Andrew

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2011-12-11 02:28:00 Re: Hope for a new PostgreSQL era?
Previous Message Jack Christensen 2011-12-10 20:39:35 Re: Why does aggregate query allow select of non-group by or aggregate values?