POSTGRESQL VERSION 9.0 CHEAT SHEET
POSTGRESQL VERSION 9.0 CHEAT SHEET
postgresql90_cheatsheet_a4
PG_CATCHECK-MASTE
PG_CATCHECK-MASTE
1) Download pg_catcheck-master.zip from below link:
https://github.com/EnterpriseDB/pg_catcheck
unzip pg_catcheck-master.zip
2) Export below parameters:
[root@localhostpg_catcheck-master]# export LD_LIBRARY_PATH=/opt/PostgresPlus/9.3AS/lib/
ERROR REPORTING AND LOGGING
ERROR REPORTING AND LOGGING
19.8.1. Where To Log
log_destination (string)
PostgreSQL supports several methods for logging server messages, including stderr, csvlog and syslog. On Windows, eventlog is also supported. Set this parameter to a list of desired log destinations separated by commas. The default is to log to stderr only.