If you want to connect withoud ssl, you can try this apporach, by setting a function infront of the postgresql node with this content:
msg.pgConfig = {
user: 'kafkatopostgresqlv2', // default process.env.PGUSER process.env.USER
password: 'changemetoo', // or function, default process.env.PGPASSWORD
host: 'united-manufacturing-hub.united-manufacturing-hub.svc.cluster.local', // default process.env.PGHOST
database: 'umh_v2', // default process.env.PGDATABASE process.env.USER
port: 5432, // default process.env.PGPORT
ssl: {
rejectUnauthorized: false // SSL is on but verification is not done
},
}
return msg;
Then set in the postgresql node ssl to true and it should work