Re: Postgres replication solutions

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