Replicating hundreds of thousandw of rows - Mailing list pgsql-general

From Job
Subject Replicating hundreds of thousandw of rows
Date
Msg-id 88EF58F000EC4B4684700C2AA3A73D7A08054EAEBAE3@W2008DC01.ColliniConsulting.lan
Whole thread Raw
Responses Re: Replicating hundreds of thousandw of rows  (Simon Riggs <simon@2ndquadrant.com>)
Re: Replicating hundreds of thousandw of rows  (Moreno Andreo <moreno.andreo@evolu-s.it>)
List pgsql-general
Hello,

we need to replicate hundreds of thousands of rows (for reporting) between Postgresql Database nodes that are in
differentlocations. 

Actually, we use Rubyrep with Postgresql 8.4.22.
It works fine but it is very slow with a massive numbers of rows.

With Postgresql 9.x, are there some ways to replicate (in background, not in real time!), these quantities of data?
We need a periodical syncronization..,

Thank you!
/F

pgsql-general by date:

Previous
From: pinker
Date:
Subject: pg_am access in simple transaction?
Next
From: Simon Riggs
Date:
Subject: Re: Replicating hundreds of thousandw of rows