On 12/02/10 15:37, Fujii Masao wrote:
On Sat, Feb 13, 2010 at 12:28 AM, Robert Haas<robertmh...@gmail.com>  wrote:
Well, let's come up with something else then.

continuous_recovery ?

One problem with the otherwise entirely wonderful HS/SR pairing is the whole business of the config parameters. They feel too bottom-up. Individually, each one makes sense but if you look at them on a page they don't say master/slave replication to me.

What about something like:

# Primary
archive_mode             = producer
archive_producer_command = 'cp "%p" .../"%f"'
max_consumers            = 5


# Standby
archive_mode = producer, consumer
archive_producer_command = 'cp "%p" .../"%f"'
archive_consumer_command = 'cp "%p" .../"%f"'
consume_from             = 'host=... user=...'

Three other points that struck me:
1. Why have a separate recovery.conf file rather than just put the commands inline? We can use the include directive to have them in a separate file if required. 2. Why have a finish.replication file, rather than "SELECT pg_finish_replication()"?

--
  Richard Huxton
  Archonet Ltd

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to