Preface
Secure Agent services
- Setting custom environment variables
- Configuring a restart schedule
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
- Data Access Management Agent service properties
Data Access Management Proxy service
- Compatible database drivers
- 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
DV Processor
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
- Rolling upgrades
  - Rolling upgrade error handling
SecretManagerApp
Configuring Secure Agent service properties

Secure Agent Services

Back Next

Configuring PostgreSQL log rotation

The PostgreSQL log contains logging information for the PostgreSQL database that is packaged with the Secure Agent.

The PostgreSQL log is available in the following directory:

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

The PostgreSQL log can become very large and difficult to manage over time. You can configure log rotation to reduce the file size and manage the file easily. You can configure log rotation based on time or file size.

Create a file named

user.conf

in the following location if it does not already exist:

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

The

user.conf

file overrides the values defined in the

postgresql.conf

file.

Perform one of the following steps:

To rotate the logs based on time, add the following properties to the

user.conf

file:

log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log'
log_rotation_age=<value in minutes>

For example, if you set the value of the log_rotation_age property to 1440, the log file will be rotated every day.

To rotate the logs based on file size, add the following properties to the

user.conf

file:

log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log’
log_rotation_size=<value in kilobytes>
log_truncate_on_rotation=on

For example, if you set the value of the log_rotation_size property to 10240, the log file will be rotated when the file size exceeds 10 MB.

Save the

user.conf

file.

Restart the PostgreSQL database for the change to take effect.

Process Server

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

Secure Agent Services

Secure Agent Services

Configuring PostgreSQL log rotation

Configuring PostgreSQL log rotation