Re: Postgres replication solutions

[Jeff Frost <jeff(at)frostconsultingllc(dot)com>]

Mario,

There's also Command Prompt's Mammoth replicator: 
http://commandprompt.com/products/mammothreplicator/

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.

Another option is using pgpool's replication.

On Fri, 28 Jul 2006, Mario Splivalo wrote:

> Besides slony, is there any other postgres replication active project? I
> I need a solution where I could mirror a database to a 'spare' server,
> for statistical analysis (just SELECTs beeing done there), and 'lag'
> between actuall data and the slave server synchronisation can be even
> few hours.
>
> It would be awesome if it's not trigger-based.
>
> I looked on gborg.postgres.org, there are numerous replication projects,
> but for most of them last activity was in 2002. On pgfoundry I found
> nothing (I haven't spent much time there since the web-site is awfully
> slow).
>
> So, I'd like a recommendation.
>
> 	Mario

--
Jeff Frost, Owner 	<jeff(at)frostconsultingllc(dot)com>
Frost Consulting, LLC 	http://www.frostconsultingllc.com/
Phone: 650-780-7908	FAX: 650-649-1954