Article - CS350444
"psql: FATAL: password authentication failed for user" is seen when executing thingworxPostgresDataTableDataUpdate, thingworxPostgresStreamDataUpdate or thingworxPostgresValueStreamDataUpdate during upgrade to ThingWorx Platform 9
Modified: 10-Aug-2021
Applies To
- ThingWorx Platform 9.0 to 9.5
- PostgreSQL
Description
- password authentication failed for user when attempting to run one of the following upgrade scripts during upgrade to ThingWorx Platform 9
- Windows
- thingworxPostgresStreamSchemaUpdate.bat
- thingworxPostgresDataTableSchemaUpdate.bat
- thingworxPostgresValueStreamSchemaUpdate.bat
- Linux
- thingworxPostgresStreamSchemaUpdate.sh
- thingworxPostgresDataTableSchemaUpdate.sh
- thingworxPostgresValueStreamSchemaUpdate.sh
- Windows
- Cannot complete upgrade of ThingWorx Platform to 9.x due to failure of upgrade scripts
- ThingWorx Platform 9 upgrade scripts do not execute correctly
- Cannot upgrade ThingWorx Platform backed by PostgreSQL
- Password error is seen when executing ThingWorx Platform 9 PostgreSQL upgrade scripts
- Tried specifying PostgreSQL Database Password with the -r option and PGPASSWORD but password authentication error is still seen
- How to set PGPASSWORD Environment Variable for use with ThingWorx Platform 9 upgrade scripts
- Following error is seen in the Command Line or Terminal
- psql: FATAL: password authentication failed for user "<ThingWorx Database User>"
thingworxPostgres<Table>DataUpdate.sh: line 75: [: -eq: unary operator expected
psql: FATAL: password authentication failed for user "<ThingWorx Database User>"
thingworxPostgres<Table>DataUpdate.sh: line 83: [: -eq: unary operator expected
Table [value_stream] has migrated data starting with ID: . Migrating records only with ID before
psql: FATAL: password authentication failed for user "<ThingWorx Database User>"
thingworxPostgres<Table>DataUpdate.sh: line 96: [: -lt: unary operator expected
psql: FATAL: password authentication failed for user "<ThingWorx Database User>"
Starting to migrate in descending order from Id
psql: FATAL: password authentication failed for user "<ThingWorx Database User>"
thingworxPostgres<Table>DataUpdate.sh: line 111: [: -10000: unary operator expected"
- psql: FATAL: password authentication failed for user "<ThingWorx Database User>"
This is a printer-friendly version of Article 350444 and may be out of date. For the latest version click CS350444