G
G
gremlintv22018-12-30 04:46:30
PostgreSQL
gremlintv2, 2018-12-30 04:46:30

With postgresql-10 asynchronous replication, is it possible to change the slave config for a different hardware or is it excluded?

There is a database for writing, it is planned to replicate slaves to several weaker nodes that, in terms of RAM, will not drag the master config, is it possible to modify the slave config by optimizing it through pgtune and run it with subsequent replication, or is this excluded?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
M
Melkij, 2018-12-30
@gremlintv2

For streaming replication, the following settings must be set on the replica :
wal_level from the master is not lower than replica
max_connections, max_worker_processes, max_prepared_transactions, max_locks_per_transaction equal or greater than on the master.
For the sake of order, I will mention that the hardware architecture of the processor must be identical, it will not be possible to replicate from x86-64 to arm.
Everything else may vary. The main thing is that the disks on the replicas have time to write a stream of changes.

K
ky0, 2018-12-30
@ky0

Can. Only at what here asynchronous replication?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question