Question

#PostgreSQL cluster restoration - restores incorrect configuration

  • 6 January 2023
  • 5 replies
  • 76 views

Badge +4

Hello Team,

Here is the setup information,

OS type: SLES12

Affected DB version: v11 and v13 

4 nodes running on streaming replication method (SYNC). 

Scenario: 

We have 4 node cluster running on SYNC replication method with cluster_name parameter configured on each data nodes (like node1 → cluster_name=’node1’) and so on.

Now that, we have successfully taken the backup along with some archive logs. 

Backups are ran from primary (node1). 

We performed all the pre-reqs before we started the restoration on node1. Restoration went fine without any warnings, however we happen to see that the restored postgresql.conf on node1 had below entry,

cluster_name='node2' 

where we expect it to have 'node1’ 

Kindly check and confirm this behavior. 

Regards,

Kamal

 

 


5 replies

Userlevel 4
Badge +13

Hi @Kamal Kumar 

Is this a Master / Standby configuration with 1 Master and 3 standby setup or is this a OS cluster hosting PostgreSQL DB on the virtual node ?

Regards,

Gowri Shankar

Badge +4

Hi @Gowri Shankar 

Its a 4 node cluster, running with 1 master and 3 standby nodes setup in synchronous streaming replication method. 

Regards,

Kamal

Badge +4

Also, it is not based on OS level clustering. 

Badge +4

If you are confused; “cluster_name" parameter is from postgresql.conf file. 

Badge +4

Let me know if you need further clarification. 

Reply