Upgrade to postgres database 12.5 failed

[maxho]

Hi all,

I am new to qlik, Upgrade to postgres database version 12.5 failed with error message database backup failed and the directory name invalid. Please see troubleshooting steps below

Upgrade of Qlik from Feb 2021 to Nov 2022 successful.

Upgrade of PostgreSQL database from version 9.6 to 12.5 unsuccessful. 

During the upgrade of postgres database to version 12.5

Setup detect c:\program files\qlik\sense\repository\postgressql\9.6 but it is wrong path for ProgresSQL  database

My PostgreSQL database path  is D:\Program Files\Qlik\Sense\Repository\PostgreSQL\9.6\bin and subsequently give 

the error message database backup failed. Please see error log below.

ERROR LOG

2023-01-31 14:37:51.295 +08:00 [INF] Creating directory: C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\backup\9.6.
2023-01-31 14:37:51.299 +08:00 [INF] Dumping database using binaries dir: C:\Program Files\Qlik\Sense\Repository\PostgreSQL\9.6\bin with command argument: /c pg_dumpall.exe -p 4432 -U postgres -f "C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\backup\9.6\postgres_installer_database.backup"
2023-01-31 14:37:51.309 +08:00 [ERR] Exception when dumping database: The directory name is invalid.
2023-01-31 14:37:51.315 +08:00 [INF] Task:BackupDatabaseTask completed with exception: Qlik.PostgreSQL.Installer.Utility.Exceptions.DumpDatabaseFailedException: Dump database failed
---> System.ComponentModel.Win32Exception (267): The directory name is invalid.2023-01-31 14:37:51.295 +08:00 [INF] Creating directory: C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\backup\9.6.
2023-01-31 14:37:51.299 +08:00 [INF] Dumping database using binaries dir: C:\Program Files\Qlik\Sense\Repository\PostgreSQL\9.6\bin with command argument: /c pg_dumpall.exe -p 4432 -U postgres -f "C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\backup\9.6\postgres_installer_database.backup"
2023-01-31 14:37:51.309 +08:00 [ERR] Exception when dumping database: The directory name is invalid.
2023-01-31 14:37:51.315 +08:00 [INF] Task:BackupDatabaseTask completed with exception: Qlik.PostgreSQL.Installer.Utility.Exceptions.DumpDatabaseFailedException: Dump database failed
---> System.ComponentModel.Win32Exception (267): The directory name is invalid.

[Benoit_C · Accepted solution]

Hello @maxho,

In order to migrate the Postgres Database I'm understanding that you have used our tool from below article:

https://community.qlik.com/t5/Official-Support-Articles/Upgrading-Qlik-Sense-Repository-Database-fro...
 

The current version of this tool is: 1.2.1 

This version still not support when a custom installation (other than c:\program files\Qlik\Sense) is used.

The solution would be either to wait the new release, or to upgrade your Postgrs version with another method;

https://community.qlik.com/t5/Official-Support-Articles/How-to-manually-upgrade-the-bundled-Qlik-Sen...

About the version which will support a custom installation and if no issues in between, it will be into our May release plans.


Edit: In another hand, it seems that there is a workaround that several customers tried successfully.

In below article, you'll fond some conversation about it:

https://community.qlik.com/t5/Official-Support-Articles/Upgrading-Qlik-Sense-Repository-Database-fro...

"While the old Database was only supported to be installed into this folder, when using the embedded version C:\programdata\qlik\sense\repository\postgresql\9.6

the postgres binary folder could be in E:\Program Files\Qlik\Sense\Repository\PostgreSQL\9.6.

If that is the case you simply copy the folder E:\Program Files\Qlik\Sense\Repository\PostgreSQL\9.6 to C:\Program Files\Qlik\Sense\Repository\PostgreSQL\9.6 and run the QPI installer. After that you can delete the folder on the C: drive again."

So for you, the woraround would be to copy D:\Program Files\Qlik\Sense\Repository\PostgreSQL\9.6 to C:\Program Files\Qlik\Sense\Repository\PostgreSQL\9.6 and run the QPI installer.
 

Regards,

Benoit