Community Tip - You can change your system assigned username to something more personal in your community settings. X
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,
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
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
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.