LoginSignup
0
0

More than 5 years have passed since last update.

How to use loggly to monitor PostgreSQL

Posted at
# curl -O https://www.loggly.com/install/configure-linux.sh
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
100 27058  100 27058    0     0  22318      0  0:00:01  0:00:01 --:--:-- 22325

# sudo bash configure-linux.sh -a SUBDOMAIN -u USERNAME
Username is set
Please enter Loggly Password:********
INFO: Initiating Configure Loggly for Linux.
INFO: Operating system is CentOS.
INFO: Checking if logs-01.loggly.com is reachable.
INFO: logs-01.loggly.com is reachable.
INFO: Checking if logs-01.loggly.com is reachable via 514 port. This may take some time.
INFO: logs-01.loggly.com is reachable via 514 port.
INFO: Checking if 'clalpha' subdomain is valid.
INFO: https://clalpha.loggly.com is valid and reachable.
INFO: Checking if Gen2 account.
INFO: It is a Gen2 account.
INFO: Checking if provided username and password is correct.
INFO: Username and password authorized successfully.
INFO: Authentication token not provided. Trying to retrieve it from https://clalpha.loggly.com account.
INFO: Retrieved authentication token: da7f991b-bdf3-4041-8d26-193818c5129a
INFO: Checking if provided auth token is correct.
INFO: Authentication token validated successfully.
INFO: Systemd is present. Configuring logs from Systemd to rsyslog.
INFO: Restarting Systemd-journald
INFO: rsyslog is present as service.
INFO: Modified $MaxMessageSize to 64k in rsyslog.conf
INFO: Restarting the rsyslog service.
Redirecting to /bin/systemctl restart  rsyslog.service

# sudo vim /etc/rsyslog.conf

$ModLoad imudp
$UDPServerRun 514

# sudo service rsyslog restart

# vi postgresql.conf

log_destination = 'syslog'

# 
0
0
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
0
0