Having problems with your account or logging in?
A lot of changes are happening in the community right now. Some may affect you. READ MORE HERE
Highlighted
Micro Focus Frequent Contributor
Micro Focus Frequent Contributor
123 views

PostgreSQL MC ServiceGuard/Veritas cluster-aware client

Jump to solution

Hello, please consider adding support of PostrgeSQL 9.x/10.x Active/Standby (RHEL 7.5 /OEL 7.x) on HPE MC ServiceGuard/Veritas Cluster for DP 10.30 and future releases.

Labels (1)
0 Likes
1 Solution

Accepted Solutions
Knowledge Partner Knowledge Partner
Knowledge Partner

Re: PostgreSQL MC ServiceGuard/Veritas cluster-aware client

Jump to solution

Hi Alex,

Have you checked the integration section for PostgreSQL?

https://docs.microfocus.com/itom/Data_Protector:2019.02/PostgreSQLConfigureInstance#Configure_PostgreSQL_Instance_-_Standby_Server

As already mentioned, Data Protector is highly flexible and there is no benefit of official supporting a cluster stack that does not add anything to the table.

What is supported already is the concept of physical and virtual hosts that can be applied to various scenarios such as:

  • Using a dedicated backup interface
  • Open source clusters such as Heartbeat, Pacemaker, etc.
  • Hot standby systems where a virtual name is used to backup
  • ...

I prefer to use what is already there and works well. Hope this helps.

Regards,
Sebastian Koehler

---
Please use the Like button below, if you find this post useful.
0 Likes
5 Replies
Knowledge Partner Knowledge Partner
Knowledge Partner

Re: PostgreSQL cluster-aware client

Jump to solution

Hi @Kozloviv,

Can you please describe the exact setup you're looking for?

Is there just a PostgreSQL package just moving between nodes using Serviceguard? If yes, this is already covered. Or is this a setup where you have an active and standby database?  If yes, this is also covered.

If you setup Data Protector correctly (import physical hosts as usual and packages as virtual hosts) you should be fine. Just configure the backup to use virtual hosts.

The same applies to other cluster solutions such as Pacemaker/Corosync. (I asked the admins to remove the duplicate post.)

Regards,
Sebastian Koehler

---
Please use the Like button below, if you find this post useful.
0 Likes
Micro Focus Contributor
Micro Focus Contributor

Re: PostgreSQL MC ServiceGuard/Veritas cluster-aware client

Jump to solution

Hi Sebastian,

We are talking about official support of PostgreSQL active/standby functionality. Currently, in DP 10.30, there is no support for standby DB like we have for Oracle, where during the integration process you are able to setup both primary and standby databases.

So, the same for UNSUPPORTED 3rd-party clustered software based on Corosync Cluster Engine  2.x.x & Pacemaker 1.1.xx packeges,

Could you show us how to setup the "supported" standby DB in our DP documentation?

WBR,
Alex

0 Likes
Knowledge Partner Knowledge Partner
Knowledge Partner

Re: PostgreSQL MC ServiceGuard/Veritas cluster-aware client

Jump to solution

Hi Alex,

Have you checked the integration section for PostgreSQL?

https://docs.microfocus.com/itom/Data_Protector:2019.02/PostgreSQLConfigureInstance#Configure_PostgreSQL_Instance_-_Standby_Server

As already mentioned, Data Protector is highly flexible and there is no benefit of official supporting a cluster stack that does not add anything to the table.

What is supported already is the concept of physical and virtual hosts that can be applied to various scenarios such as:

  • Using a dedicated backup interface
  • Open source clusters such as Heartbeat, Pacemaker, etc.
  • Hot standby systems where a virtual name is used to backup
  • ...

I prefer to use what is already there and works well. Hope this helps.

Regards,
Sebastian Koehler

---
Please use the Like button below, if you find this post useful.
0 Likes
Micro Focus Frequent Contributor
Micro Focus Frequent Contributor

Re: PostgreSQL MC ServiceGuard/Veritas cluster-aware client

Jump to solution

Hello @Sebastian.Koehler , we did not expect to find the information in this specific part of the documentation. Your feedback is very useful, thank you very much. I guess this idea is not actual anymore.

0 Likes
Knowledge Partner Knowledge Partner
Knowledge Partner

Re: PostgreSQL MC ServiceGuard/Veritas cluster-aware client

Jump to solution

Hi @Kozloviv,

Wonderful we found a solution for you. @skochavaracan we move this to the Data Protector discussion board?

Regards,
Sebastian Koehler

---
Please use the Like button below, if you find this post useful.
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.