Sample Header Ad - 728x90

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