New Ranks & Badges For The Community!
Notice something different? The ranks and associated badges have gone "Star Fleet". See what they all mean HERE
Highlighted
Knowledge Partner Knowledge Partner
Knowledge Partner
509 views

DB migration on appliance

Jump to solution

I have a ZCM 2017 Update 4 appliance.  I assume the DB migration steps apply to appliances also.  So I am planning the DB migration, but the docs are a little lacking in information.  The appliance migration docs here https://www.novell.com/documentation/zenworks-2020/zen_upgrade/data/brivl5j.html point to these docs for the db migration: https://www.novell.com/documentation/zenworks-2020/zen_sybase_postgre_migration/data/zen_sybase_postgre_migration.html

But the db migration docs don't provide any specific info regarding appliances.

1. Does the migration tool install the PostgreSQL db?  (I assume not)

2. If not, which version of PostgreSQL should be installed on a 2017 appliance?  (The docs offer three versions with no direction as to which one is applicable for the appliance.)

 

--
Ken
Knowledge Partner

Create and vote for enhancements in the Idea Exchange forums!
Don't forget to Like helpful posts and mark Solutions!
Labels (3)
1 Solution

Accepted Solutions
Highlighted
Micro Focus Expert
Micro Focus Expert

Just follow your link here for migrating to Embedded PostgreSQL (1.1)

https://www.novell.com/documentation/zenworks-2020/zen_sybase_postgre_migration/data/zen_sybase_postgre_migration.html

Just assume you are using Linux for the path.

And yes.....The Migration Tool ZIP will install PostgreSQL for you.

Clearly make a Snapshot before starting......And there are scripts to roll back to Sybase if you have issues.

--
Please give a hearty thumbs up to any post you find helpful!
To find articles by Craig Wilson simply follow the link: Craig Wilson's Tips!

View solution in original post

6 Replies
Highlighted
Micro Focus Expert
Micro Focus Expert

Just follow your link here for migrating to Embedded PostgreSQL (1.1)

https://www.novell.com/documentation/zenworks-2020/zen_sybase_postgre_migration/data/zen_sybase_postgre_migration.html

Just assume you are using Linux for the path.

And yes.....The Migration Tool ZIP will install PostgreSQL for you.

Clearly make a Snapshot before starting......And there are scripts to roll back to Sybase if you have issues.

--
Please give a hearty thumbs up to any post you find helpful!
To find articles by Craig Wilson simply follow the link: Craig Wilson's Tips!

View solution in original post

Highlighted
Knowledge Partner Knowledge Partner
Knowledge Partner

Thanks Craig!  Unless I am somehow missing it (and I read that page multiple times), I don't see anywhere on that page that it states that the migration tool will install the embedded PostgreSQL.  That is why I was confused about it.  Thanks for clarifying it!

--
Ken
Knowledge Partner

Create and vote for enhancements in the Idea Exchange forums!
Don't forget to Like helpful posts and mark Solutions!
0 Likes
Highlighted
Commander
Commander

Hello,

I want to go one step further.

I want to move the embedded postgresql db from 1 primary 2020 server to an appliance 2020 server as also an embedded postgresql db. The reason is to remove the old SLES 11 primary server.

the db migration tool 3.0 dont support this?

Is there any documentation to do this?

Have I  go to backup and restore the db?  If yes, is the db engine installed on the second primary appliance?

A external postgresql db is not an option for small environments.

Thanks for any documents for this migration path.

 

Andy

0 Likes
Highlighted
Micro Focus Expert
Micro Focus Expert

The best I can recommend is open an SR and have an engineer work with you.

I know at least one person who has assisted in this process.

Yes...the Docs in this area are incomplete at this point in time.  Requests for updates are pending to help flush out the doc.

--
Please give a hearty thumbs up to any post you find helpful!
To find articles by Craig Wilson simply follow the link: Craig Wilson's Tips!
0 Likes
Highlighted
Micro Focus Expert
Micro Focus Expert

And FYI......

Getting this Fixed/Updated in the Docs is a priority.

It was already a work in progress and was supposed to have updated details with the release of 2020.1, but some additional tweaks were needed on the docs based upon internal testing so they need to run through processes again.....

Sounds like you did open an SR and your engineer is looped in with the folks finalizing the doc.

--
Please give a hearty thumbs up to any post you find helpful!
To find articles by Craig Wilson simply follow the link: Craig Wilson's Tips!
Highlighted
Commander
Commander

That´s right.

I have opend a SR call 101299656221.

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.