Replicating hundreds of thousandw of rows

From: Job <Job(at)colliniconsulting(dot)it>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Replicating hundreds of thousandw of rows
Date: 2016-11-25 14:23:43
Message-ID: 88EF58F000EC4B4684700C2AA3A73D7A08054EAEBAE3@W2008DC01.ColliniConsulting.lan
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

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

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Simon Riggs 2016-11-25 14:52:30 Re: Replicating hundreds of thousandw of rows
Previous Message pinker 2016-11-25 12:40:31 pg_am access in simple transaction?