cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - You can subscribe to a forum, label or individual post and receive email notifications when someone posts a new topic or reply. Learn more! X

help needed with thingworx flow 9.3.4 install error

BS_10420068
4-Participant

help needed with thingworx flow 9.3.4 install error

I have thingworx foundation postgres 9.3.4 on Windows Server 2019 and works fine.

Trying to install thingworx flow postgres 9.3.4 and at the very end of installation, I get this error.

And all the installed files including log files gets removed instantly.

How should I solve this?


[execute] 'psql' is not recognized as an internal or external command,
operable program or batch file.
[2022-11-30T19:21:59+09:00] INFO: execute[postgres init] failed with: #<Mixlib::ShellOut::ShellCommandFailed: Expected process to exit with [0], but received '1'
---- Begin output of psql -h localhost -p 5432 -U postgres -d thx -f "E:\ThingWorxFlow\modules\db_seed\postgres_init.sql" ----
STDOUT:
STDERR: 'psql' is not recognized as an internal or external command,

4 REPLIES 4
PaiChung
22-Sapphire I
(To:BS_10420068)

Based on the error here is my guess

I would add where ever your psql.exe is located to the Path environmental variable?

Seems like it is trying to execute a postgres action but it can't find psql.exe

BS_10420068
4-Participant
(To:PaiChung)

The Path environment is already there.

Postgres 14 is locally installed and Thingworx foundation has been installed and database settings are done without any problems.

Thingworx flow is having problems and can't find a way to solve..

 

psql command runs in shell.

 

For installation settings, I tried both below

1. use thingworx foundation database as flow database

2. create new database for flow

slangley
23-Emerald II
(To:BS_10420068)

Hi @BS_10420068.

 

I recommend we open a case for this issue.  We need to see what is going on in your environment.

 

If you agree, I'm happy to open a case on your behalf.

 

Regards.

 

--Sharon

It looks like it can't run the command psql to connect to the Postgres database.  Is Postgres installed locally on this machine?  If not make sure psql tool is installed and accessible from PowerShell or command prompt.

Top Tags