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 more than one installed server, you'll find a unique server log for each
server; you can use the settings in the postgresql.conf file to control the amount of content saved, the file
rotation, 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 |