real-time sync between local Postgres instance and Azure Cloud Postgres instance

Question

I need to set up real time sync process between a on premise postgresql instance with cloud postgresql instance. Please let me know what are all the options available through which i can achieve it.

Do i have to use any specific tool or it can be managed through replication .

Please advice

Muhammad Muntaza · Accepted Answer · 2017-05-30 05:59:32Z

1

Use PgPool

http://www.pgpool.net/mediawiki/index.php/Main_Page

from their web page:

pgpool-II can manage multiple PostgreSQL servers. Using the replication function enables creating a realtime backup on 2 or more physical disks, so that the service can continue without stopping servers in case of a disk failure.

answered May 30, 2017 at 5:59

Muhammad Muntaza

801 silver badge6 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

real-time sync between local Postgres instance and Azure Cloud Postgres instance

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related