Обсуждение: replication set-up

On Fri, Sep 9, 2011 at 8:02 AM, ScientificWare-Luigi D'Angelo
<luigi@scientificware.it> wrote:
> Hello everyone
> i'm totally new to postgresql. I am trying to learn how to set up a
> streaming replication.
> I've prepared my "primary" server and i would need a streaming replication
> on a  "hot standby"
>
> I'm reading the official guide downloaded from the postgre web page.
> I do understand the theory of how SR has to work, but the whole thing seems
> a little bit odd to set up and manage.
> I was wondering if there is some GUI tool to set-up, control and manage the
> replication with.
>
> I tried repmgr via command line, but i'm having problems while trying to
> compile the source on my Fedora15 test server

I had similar problems, and ended up having to get the full postgres
source and building repmgr against it.  repmgr seems to have a lot of
rough edges which aren't helped much by very limited support.  FWIW,
repmgr isn't a GUI so if that's your requirement, its not going to
help.

pgpool can be used for managing a database cluster with streaming
replication, and does have a web admin interface.

Il 09/09/2011 17:05, Lonni J Friedman ha scritto:
> I had similar problems, and ended up having to get the full postgres
> source and building repmgr against it.  repmgr seems to have a lot of
> rough edges which aren't helped much by very limited support.  FWIW,
> repmgr isn't a GUI so if that's your requirement, its not going to
> help.
Yes, i know, it was my second choice in case of no GUI available at all:
its command seemed easier to use against setting up .conf files and triggers

>
> pgpool can be used for managing a database cluster with streaming
> replication, and does have a web admin interface.
I'll try pgpool
Thank You