Skip to main content
B
BS_104200684-Participant
4-Participant
November 30, 2022
Question

help needed with thingworx flow 9.3.4 install error

  • November 30, 2022
  • 2 replies
  • 2331 views

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,

2 replies

P
PaiChung22-Sapphire I
22-Sapphire I
December 5, 2022

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

B
BS_104200684-ParticipantAuthor
4-Participant
December 13, 2022

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

S
slangleyCommunity Manager
Community Manager
December 13, 2022

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

T
TravisPickett12-Amethyst
12-Amethyst
December 5, 2022

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.

    Terms & ConditionsAccessibility statement