This video explains how to connect to PostgreSQL DB from Linux Agent.
For further information, refer to the following documents:
• Connect to PostgreSQL DB on Linux:
https://knowledge.informatica.com/s/article/513364?language=en_US
• Truncate aeprocesslogdata table in Postgres DB:
https://knowledge.informatica.com/s/article/How-to-truncate-APROCESSLOGDATA-table-in-Postgres-database?language=en_US
• DB related issues:
https://knowledge.informatica.com/s/article/577625?language=en_US
• Install or upgrade PostgreSQL DB with scripts:
https://docs.informatica.com/cloud-common-services/administrator/current-version/secure-agent-services/process-server/prerequisites-for-postgresql-database-installation-and-upgrade.html