From: Rafael Domiciano <rafael.domiciano@gmail.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Downtime
Date: Mon, 16 Feb 2009 16:52:37 -0300
Message-ID: <3a0028490902161152l13cc82eva6b26c013776cbcf@mail.gmail.com> (raw)
Hello for all,
Our bussiness do not tolerate anymore downtime (the downtime is estimate at
10 hour / year - that involves upgrade of hardware, crash of hardware), and
using Slony-I 1.2.15 I have waste time to put the slave node on production.
So I'm studying some replications softwares, like pgpool, pg_cluster,
pg_replicator.
Pgpool has a good idea, I can connect at 2 servers or more at the same time.
But I have some limitations, like Replication, Datas generated by the
servers (CURRENT_DATE, CURRENT_TIME, serial, oid); so I discarded it.
I tryed pg_cluster, but the documentation is very poor, and the installation
was unsuccesfull.
I would like to know from you what solution you uses for avoiding downtime,
so I could choose the solution that is best to my scenario and for others
that is begining in Postgres and is a little lost in replication.
Thnks for all,
Rafael Domiciano
DBA Postgres
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: rafael.domiciano@gmail.com
Subject: Re: Downtime
In-Reply-To: <3a0028490902161152l13cc82eva6b26c013776cbcf@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox