Preface
Secure Agent services
- Setting custom environment variables
API Microgateway Service
- Editing the API Microgateway Service properties
- Enabling the API Microgateway Service in a Secure Agent or a Secure Agent group
CMI Streaming Agent
- CMI Streaming Agent properties
Common Integration Components
- Common Integration Components properties
Connector Service
- Connector Service properties
Data Access Management Agent service
- Compatible database drivers
- Data Access Management Agent service properties
Data Access Management Proxy service
- Data Access Management Proxy service properties
Database Ingestion service
- Database Ingestion service properties
- Database Ingestion Agent environment variables
Data Integration Server
- Data Integration Server resiliency
- Data Integration Server properties
  - Creating the OSProfileUserMappingFile
  - Setting the OSProfileScriptForTaskExecution
- Data Integration Server upgrades
Elastic Server
- Elastic Server properties
- Elastic Server concurrency
File Integration Service
GitRepoConnectApp
- Local repository base directory
- GitRepoConnectApp properties
IDMC Data Gateway Service
- IDMC Data Gateway Service properties
Mass Ingestion (Files)
Metadata Foundation Application
- Metadata Foundation Application properties
Metadata Platform Service
- Metadata Platform Service properties
Process Server
- Process Server properties
- Process Server sizing recommendations
- Communication with the Secure Agent
- Secure Agent configurations for Process Server
  - Deploy to a single Secure Agent
  - Deploy to a Secure Agent group
- Prerequisites for PostgreSQL database installation and upgrade
- Managing the PostgreSQL database on Windows
- Managing the PostgreSQL database on Linux
- Upgrading the PostgreSQL database
- Upgrading the PostgreSQL database using the replication technique
- PostgreSQL configuration files
- Configuring PostgreSQL log rotation
- Configuring public certificates and private keys for Process Server
- Configuring thread pool profile to improve throughput
- Overriding properties in the platform.yaml file
  - Creating a custom user-platform.yaml file
  - Troubleshooting
SecretManagerApp
Configuring Secure Agent service properties

Secure Agent Services

Back Next

Managing the PostgreSQL database on Linux

Use binaries utility scripts to manage the PostgreSQL database.

To manage the PostgreSQL database, you must log in as a user who does not have root access. A root user will be unable to run PostrgreSQL binaries and utility scripts.

Informatica has created some utility script based on PostgreSQL binaries. These utility scripts make it easier for you to manage the PostgreSQL database.

The following directories contain files for the PostgreSQL database:

PostgreSQL binaries:

<Secure Agent installation directory>/apps/process-engine/data/db/postgresql-linux-x64-binaries/pgsql/bin

PostgreSQL utility scripts:

<Secure Agent installation directory>/apps/process-engine/data/db/util

PostgreSQL logs:

<Secure Agent installation directory>/apps/process-engine/logs/PostGreSql/postgresql.log

PostgreSQL data:

<Secure Agent installation directory>/apps/process-engine/data/PostGreSql/Data

For more information about PostgreSQL scripts, see the PostgreSQL help at https://www.postgresql.org/docs/current/static/index.html.

Some sections contain sample commands that use the following default values:

Default database name: activevos