in PostgreSQL REPMGR Master-Slave environment is it necessary to have same H/W config for HOT STANDBY setup?
0
votes
2
answers
290
views
I have a **PostgreSQL repmgr Master-Slave setup with HOT standby enabled**. In such repmgr configuration isnt it possible to configure the postgresql.conf in Primary and secondary DIFFERENTLY WHILE HOT STANDBY WILL BE ON. I mean parameters below:
- *shared_buffers,*
- *max_parallel_workers,*
- *max_worker_process,*
- *max_connections*
etc MUST have to be same or different? If it is different then I saw the DB in secondary through some Errors. So, it ill require same H/W (Resources like RAM, CPU same) setup for both master-slave which is costly enough.
Please, I cant start my slave with less config and need a solution to work on less H/W Slave environment to be worked as HOT standby.
Asked by fahad_dba
(1 rep)
Sep 9, 2022, 04:02 PM
Last activity: Sep 11, 2022, 06:52 AM
Last activity: Sep 11, 2022, 06:52 AM