PostgreSQL Logs
PostgreSQL is one amongst the default log types supported by Site24x7 AppLogs, a cloud based log management solution. With Site24x7 you can easily find PostgreSQL data that has been separated into associated fields such as date & time, PID, message, host, log level, and user, all of which presented within a single web client. Learn more about log management with Site24x7.
Getting started
- Log in to your Site24x7 account.
- Download and install the Site24x7 Server Monitoring agent (Windows | Linux).
- Go to Admin > AppLogs > Log Profile and Add Log Profile.
Logs File Path
Each application writes logs in different folders and files. By default, PostgreSQL logs are sourced from the below-mentioned folder path for the respective Operating System. If you have logs in a different folder, you can mention it under the File Path to source them from that particular folder while creating a log profile.
Log Pattern
$DateTime:date$ [$PID$] [$User$]@[$Host$] $LogLevel$: $Message$
This is the default pattern defined by Site24x7 for parsing PostgreSQL logs based on the sample log mentioned below.
Sample Log
INFO [main] 2016-11-04 02:14:23,494 DatabaseDescriptor.java (line 143) Data files directories: [/home/local/ZOHOCORP/franklin-0532/Softwares/Cassandra/da
The above sample log can be separated into 6 fields, each of which will take its respective value from here and will then be uploaded to Site24x7.
| Field name | Field value |
| Date Time | 2016-11-04 02:14:23 |
| PID | 494 |
| User | Data files directories:DatabaseDescriptor.java |
| Host | /home/local/ZOHOCORP/franklin-0532/Softwares/Cassandra/da |
| Log Level | GET /test.txt HTTP/1.1 |
| Message | 200 |