Skip site navigation (1) Skip section navigation (2)

Re: Postgres replication solutions

From: Mario Splivalo <mario(dot)splivalo(at)mobart(dot)hr>
To: Jeff Frost <jeff(at)frostconsultingllc(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Postgres replication solutions
Date: 2006-07-29 18:59:59
Message-ID: 1154199599.18161.8.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-admin
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


In response to

Responses

pgsql-admin by date

Next:From: Jeff FrostDate: 2006-07-29 19:10:32
Subject: Re: Postgres replication solutions
Previous:From: Stefan LeitichDate: 2006-07-29 17:39:36
Subject: Can't update table rows!Probably encoding issue?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group