From: Mario Splivalo <mario.splivalo@mobart.hr>
To: Jeff Frost <jeff@frostconsultingllc.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Postgres replication solutions
Date: Sat, 29 Jul 2006 20:59:59 +0200
Message-ID: <1154199599.18161.8.camel@localhost.localdomain> (raw)
In-Reply-To: <Pine.LNX.4.64.0607281057090.11632@discord.home.frostconsulting llc.com>
References: <1154095881.18822.12.camel@localhost.localdomain>
<Pine.LNX.4.64.0607281057090.11632@discord.home.frostconsultingllc.com>
On Fri, 2006-07-28 at 11:01 -0700, Jeff Frost wrote:
> Mario,
>
> There's also Command Prompt's Mammoth replicator:
> http://commandprompt.com/products/mammothreplicator/
I sent an email asking if they have an evaluation version of some
sort...
> Also, you could batch up PITR restores or even just dump restores if the
> timing was acceptable and you could afford the replicated DB to be down during
> those batch updates.
Dump restores are what we're using now, but we're soon going to have to
abandon that approach. The dump/restore cycle takes around 20 minutes,
and we're expecting rapid growth of the database. The another problem is
that Tomcat won't release connections to postgres unless you stop it.
PIRT restores are not working for me. I did it like this: I issued
pg_start_backup, then I 'tar cvf - pg_data/ | nc destination 9876'-ed
the cluster directory, when that was done i did pg_stop_backup, after
that I deleted pg_xlog directory, and put new WAL files (created after
backup begun) in directory specified in restore.conf. I started
postgres, everything went ok. Postgres replayed wal files, and system
was ready. Then, when new WAL files arrived, I shut down postgres, put
WAL files in place, restarted postgres, but it complained, and didn't
replay newly created wal files. It only does so when I 'recreate'
original filesystem backup.
> Another option is using pgpool's replication.
I considered that too, but that adds another layer between the clients
and postgres itself, and it allows for only two servers, and I realy
don't need failover cluster capabilities.
Mike
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: mario.splivalo@mobart.hr, jeff@frostconsultingllc.com
Subject: Re: Postgres replication solutions
In-Reply-To: <1154199599.18161.8.camel@localhost.localdomain>
References: <1154095881.18822.12.camel@localhost.localdomain> <Pine.LNX.4.64.0607281057090.11632@discord.home.frostconsultingllc.com> <1154199599.18161.8.camel@localhost.localdomain>
* 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