R
R
Roman Mirilaczvili2016-10-28 17:10:49
PostgreSQL
Roman Mirilaczvili, 2016-10-28 17:10:49

What are the replication tools in PostgreSQL for a beginner?

The hobby project uses PostgreSQL 9.3 on my local machine.
There was an idea to use a remote instance on cloud hosting (via the Internet!) As a backup, that is, all calls would occur to the local database, but the remote database would contain all the latest changes made on the local one. That is, after performing INSERT, UPDATE, DELETE, the remote database would automatically synchronize all changes to the remote one with minimal delay. The database is small.
The remote database is version 9.4 and does not match the local one. The runtime and configuration, respectively, are also different.
If I understand correctly, this is called master/slave asynchronous replication.
Tell me by what means replication is done and how it will affect the settings for connecting to the database in my program (Ruby on Rails framework). It is required to replicate only one database (only the project) out of many.
I have little experience with PostgreSQL, and have never dealt with replication.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
P
Puma Thailand, 2016-10-28
@2ord

It is logical to use the standard physical implementation in postgres, it is logical that the postgres version will need to be raised to one digit.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question