Answer the question
In order to leave comments, you need to log in
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
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.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question