How to transfer PS 5.3.2 Server Edition (PG) data to PS 7.3.0?

Post Reply
yogavidyapubs
Posts: 7
Joined: 20 Jan 20 6:08

How to transfer PS 5.3.2 Server Edition (PG) data to PS 7.3.0?

Post by yogavidyapubs »

We have a licensed PSv7 and were able to get it running on our existing PostgreSQL 12 instance. I installed PostgreSQL 14, but cannot find any way to transfer data that does not result in an error.

Methods tried:
1. backup catalog from PSv5.3.2 and import into PSv7.3.0
2. use PS Data Exchange Tool v1 (link found on sticky post on forum) using PG to PG option
3. backup and restore using pgAdmin on PG14 (I'm not an experienced db admin so this one was most difficult to make any headway on, but I would love a recipe for getting this to work if it is a viable option). In particular, I'm not clear how to recreate the idimager user and set the password using SQL queries.

Can someone please recommend a tried, tested, and recommended procedure for migrating data from PostgreSQL 12 to PostgreSQL 14 where the original data is from a previous PS version? In this case PS_ServerEdition_v5.3.2.pg to PS_ServerEdition_v7.3.0.pg

The errors I am getting are reported with screenshots in the following issue:
https://mantis.idimager.com/view.php?id=3496
Attachments
PS7SE-restore failing on PgSQL 14 on 5433 (backup from PgSQL 12 on 5432).PNG
PS7SE-restore failing on PgSQL 14 on 5433 (backup from PgSQL 12 on 5432).PNG (45.61 KiB) Viewed 119 times
PS restore not working when upgraded from PG 12 to 14 on same port.png
PS restore not working when upgraded from PG 12 to 14 on same port.png (69.04 KiB) Viewed 119 times
PS restore not working when port is 5433 (5432 was backup location).png
PS restore not working when port is 5433 (5432 was backup location).png (86.57 KiB) Viewed 119 times
PSv7.pg - DataExchange gives error trying to transfer data from PG 12 to PG 14.png
PSv7.pg - DataExchange gives error trying to transfer data from PG 12 to PG 14.png (45.7 KiB) Viewed 119 times
Hert
Posts: 7347
Joined: 13 Sep 03 6:24

Re: How to transfer PS 5.3.2 Server Edition (PG) data to PS 7.3.0?

Post by Hert »

Please follow the steps as documented in the Maintenance manual (see chapter: Upgrading to a new PostgreSQL version).

https://manualsu.idimager.com/version7/ ... enance.pdf

The crux is to use pgAdmin to create a backup in the old PostgreSQL version and restore that with pgAdmin in the new PostgreSQL version)
This is a user-to-user forum. If you need product support then please send a message
yogavidyapubs
Posts: 7
Joined: 20 Jan 20 6:08

Re: How to transfer PS 5.3.2 Server Edition (PG) data to PS 7.3.0?

Post by yogavidyapubs »

Thank you, reading through the Maintenance manual helped. In particular, the instruction to use the "clean before restore option" let me get past the db issues I was encountering. The attached info panel was very helpful.

I was able to do the back and restore from PG12 to PG14 using the same version of pgAdmin which was installed with PG12.
Attachments
pg_restore.png
pg_restore.png (39.63 KiB) Viewed 54 times
Post Reply