Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ PostgreSQL log classification and management     - Ubuntu 10.04 to Ubuntu 10.10 Upgrade (Linux)

- MySQL high availability cluster fragmentation of deployment uses Cobar (Database)

- Ubuntu 14.04 + xRDP + Xfce implement Windows Remote Desktop Connection (Linux)

- Installation of Python2.7.10 under CentOS 6.4 (Linux)

- How to configure HTTP Strict Transport Security (HSTS) (Linux)

- UNIX and class UNIX system security check notes (Linux)

- Java is simple to read and write HDFS Demo (Programming)

- lack of SWAP space during installation of Oracle (Database)

- Service Discovery: Zookeeper vs etcd vs Consul (Server)

- These days have been tossing in the Linux under the ASP.NET 5, on the next in the other operating systems in the ASP.NET 5 or. NET applications, in order to complete the MS VM (CoreCLR) run is not far Reach, the effect of the application.

Cur
(Server)

- Install minimize RHEL / CentOS 7 things to do (Linux)

- CentOS boot image to achieve semi-automatic installation (Linux)

- Getting the Linux shell variable test (Programming)

- Linux system monitoring, top command of the diagnostic tool Detailed (Linux)

- Ubuntu and derivative users to install the system launcher SimDock 1.3 (Linux)

- JITwatch installation under Linux (Linux)

- In Spring AOP example explanation (Programming)

- Linux character device - automatically creates the device nodes and devices (Linux)

- AIX system file security aspects (Linux)

- MySQL query optimization: profile function (Database)

 
         
  PostgreSQL log classification and management
     
  Add Date : 2018-11-21      
         
         
         
  PostgreSQL has three kinds of logs are pg_log (database running log), pg_xlog (WAL log, that redo logs), pg_clog (transaction commit log record of the transaction metadata)

pg_log is off by default, need to set the parameters to enable this log. pg_xlog and pg_clog are forced open, not close.

1. Enable and configure logging parameters pg_log
log_destination = 'csvlog'
  logging_collector = on
  log_directory = 'pg_log'
  log_filename = 'postgresql-% Y-% m-% d_% H% M% S.log'
  log_rotation_age = 1d
  log_rotation_size = 100MB
  log_min_messages = info
  # Record slow SQL execution
  log_min_duration_statement = 60
  log_checkpoints = on
  log_connections = on
  log_disconnections = on
  log_duration = on
  log_line_prefix = '% m'
  # Monitoring database long locks
log_lock_waits = on
  # Record DDL operations
log_statement = 'ddl'

2. Restart PostgreSQL to see the newly generated log $ PGDATA / pg_log / under.
pg_ctl restart -m fast
     
         
         
         
  More:      
 
- Installation JDK 1.8 under CentOS7 (Linux)
- Using LLVM Clang and Blocks under Linux (Programming)
- Installation Elementary OS Freya 20 things to do (Linux)
- Linux beginners to develop the seven habits (Linux)
- Oracle table compression Technology Introduction (Database)
- Ubuntu installed Komodo editor by PPA (Linux)
- Shell scripts quickly deploy Tomcat project (Server)
- C ++ multithreading and critical resource instance (Programming)
- What is Unikernel? (Linux)
- Linux upgrade GCC 4.8.1 clear and concise tutorials (Ubuntu 12.04 64-bit version as an example) (Linux)
- Linux platform to prevent hackers to share practical skills (Linux)
- Linux System Getting Started Learning: From VirtualBox from the client host access NAT (Linux)
- The Definitive Guide to Linux NAT network connection (Linux)
- Remote installation of Net-SNMP whole process (Linux)
- CentOS 6.4 Python 2.6 upgrade to 2.7 (Linux)
- Lenovo E431 notebook CentOS system is installed wireless network card driver (Linux)
- Three easy open source firewall on the Linux platform (Linux)
- SpringMVC the use of interceptors (Programming)
- Fedora 22 install Adobe Flash Player (Linux)
- How to use Xmanager Remote Desktop and VNC Log (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.