Skip to main content
Question

#PostgreSQL cluster restoration - restores incorrect configuration


Forum|alt.badge.img+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

Forum|alt.badge.img+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


Forum|alt.badge.img+4
  • Author
  • 11 replies
  • January 9, 2023

Hi @Gowri Shankar 

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

Regards,

Kamal


Forum|alt.badge.img+4
  • Author
  • 11 replies
  • January 9, 2023

Also, it is not based on OS level clustering. 


Forum|alt.badge.img+4
  • Author
  • 11 replies
  • January 9, 2023

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


Forum|alt.badge.img+4
  • Author
  • 11 replies
  • January 9, 2023

Let me know if you need further clarification. 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings