Logging
pgEdge Platform log files are located in the pgedge/logs directory under the pgEdge installation. A pgEdge log file is maintained for each node of the cluster.
Server logs for PostgreSQL servers installed by pgEdge are stored in the pgedge/data/logs/pgxx subdirectory for
each installed server. If you have installed more than one version of PostgreSQL, you'll find a unique server log for each
server; you can use the settings in the postgresql.conf file to control the content saved, the file
rotation schedule, and other logged information.
The installer may modify the following PostgreSQL logging-related configuration options:
| Name | Value |
|---|---|
| log_destination | 'csvlog, stderr' |
| log_directory | /opt/pgedge/data/logs/pg16 |
| log_filename | 'postgresql-%a.log' |
| log_file_mode | 0600 |
| log_rotation_size | 1GB |
| log_min_messages | warning |
| log_min_error_statement | error |
| log_connections | on |
| log_disconnections | on |
| log_error_verbosity | verbose |
| log_line_prefix | '%t [%p]: [%l-1] user=%u,db=%d,app=%a,client=%h' |
| log_statement | 'ddl' |
| log_temp_files | 1024 |
| log_autovacuum_min_duration | '0' |
| logging_collector | on |
| log_checkpoints | on |
| log_min_duration_statement | 1000 |
| log_truncate_on_rotation | on |