K
K
Konstantin Feofantov2016-04-06 20:25:57
PostgreSQL
Konstantin Feofantov, 2016-04-06 20:25:57

How to do postgresql replication without making a change on the master?

Good day!
Once again, I need to synchronize one table without making changes on the master. On the master there is no way to do something. It is necessary, for example, to load new data from the master every few hours. On the master in the table there are only inserts.
As one of the solutions, just write a parser, but I really want something out of the box. Maybe faced, please share the solutions.
Thank you in advance!
As a result, I wrote a script, thanks for the answers.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
A
Alexander Shelemetiev, 2016-04-07
@zoroda

I don't know the solution out of the box.
I would make a connection to an external database via dblink and, on the scheduler's assignment, load the data with a request.
More cool - look towards copying WAL.
There is a video on this subject from Postgres Professional courses .

K
ky0, 2016-04-08
@ky0

To dump the table by the task from the scheduler and to recover on the second server? Or do you want only diffs/big table?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question