KB ID : 115087
Products :
Published : Aug. 7, 2018
Created : Aug. 7, 2018
Last Modified : Aug. 7, 2018

Users may come across the above error while upgrading the Vembu BDR or Vembu OffsiteDR server to latest version - v3.9.1 Update 1

If you come across this error, kindly restart VembuBDR service once and follow the below steps:

1) Open the command prompt with administrator privileges.

2) Try fetching the below query in command prompt:

psql -U postgres -p <port_value> -d SGDatabase -t -c "select max(MIGRATION_STATUS) from MIGRATION_1_6_TO_2_0"

Note: The <port_value> needs to be based on the value set in PostgreSQL.conf.

E.g. psql -U postgres -p 32010 -d SGDatabase -t -c "select max(MIGRATIONSTATUS) from MIGRATION16TO20"

3) You should be able to execute the above query from any location(Executing from PostgreSQL installation location works by default) and in some scenario, you may get the following error message:

"psql is not recognized as an internal or external command"

If you get the above error message, set the path for bin and lib folder as follows in environmental variables:

;C:\Program Files\PostgreSQL\9.6\bin ;C:\Program Files\PostgreSQL\9.6\lib

You can do this by either:

  • Using set PATH [the path] command in CMD prompt or

  • Navigating to the following path and add manually: computer → properties → advanced system settings → Environment Variables → System Variables

Note: Don't replace the PATHs that are already there just add the above-mentioned path beside them.

4) Once done adding environment variables, repeat Step 2 and you should be able to execute the Psql command from any location.

If you still experience issues, contact Vembu support at vembu-support@vembu.com

edit retag flag offensive close merge delete