Migration failure for Postgres Database with a blank space in it

Trace :

\ManageEngine\ServiceDesk\Patch\AdventNet_ManageEngine_ServiceDesk_Plus-14.2.0-SP-1.0.0\SERVICEDESK\PreInstall\pg_migrate\pgsql_old\bin\pg_dumpall.exe", -U, postgres, -p, 65433, -h, 127.0.0.1, -r, -w, |, "D:\ManageEngine\ServiceDesk\pgsql\bin\psql.exe", -U, postgres, -p, 65432, -h, 127.0.0.1, -w, servicedesk new]
Jul 11, 2023 2:16:28 AM [com.zoho.postgres.migrate.DumpMigration] [INFO] : psql: warning: extra command-line argument "new" ignored
Jul 11, 2023 2:16:28 AM [com.zoho.postgres.migrate.DumpMigration] [WARNING] : Error :::: psql: FATAL: database "servicedesk" does not exist

Cause :

In the Build version 14300(SDP) and 7000 (AE), PostgreSQL is upgraded to 11.17 from 10.21. During this upgrade, data migration will be taken place. In the process of migrating the data, above command will be executed. since the <database name> has a blank space in between, breaks into two arguments when we execute this in the command prompt.

Workaround : Rename the database to a name without space.

Shut Down the Application service.
Navigate to <Application_home_directory>\bin directory and execute "startDB.bat or startDB.sh"

Navigate to <Application_home_directory>\pgsql\bin directory and connect as "postgres" user with the below command (Refer this KB) without entering the database name.

For Windows,

psql.exe -U <username> -p <port> -h <server address>

For Linux.

./psql -U <username> -p <port> -h <server address>

Execute the below command to rename the database,

Do not connect the database that you are going to rename

ALTER DATABASE "<current database name>" RENAME TO "<database_name_without_space>";

Update the modified name into the application, by executing "changeDBServer.bat or changeDBServer.sh"
Stop the Database server by executing "stopDB.sh or stopDB.bat"

After these steps, invoke the upgrade.