Welcome to the PostgreSQLTutorial.com website! This PostgreSQL tutorial helps you understand PostgreSQL quickly. You will learn PostgreSQL fast through many practical examples. We will show you not only problems but also how to solve them creatively in PostgreSQL. If you are… You will find all you need to know to get started

PSQL Magic words:psql -U postgres Some interesting flags (to see all, use -h or –help depending on your psql version): please go through the below link https://gist.github.com/Kartones/dd3ff5ec5ea238d4c546#file-postgres-cheatsheet-md

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/ [root@localhostpg_catcheck-master]# export PATH=/opt/PostgresPlus/9.3AS/bin/:$PATH [root@localhostpg_catcheck-master]# export PG_CONFIG=/opt/PostgresPlus/9.3AS/bin/pg_config 3) In order to avoid error /usr/bin/ld: cannot find -lmemcached collect2: ld returned 1 exit status, copy below library. [root@localhostpg_catcheck-master]# cp /opt/PostgresPlus/9.3AS/lib/libmemcached.so.10 /opt/PostgresPlus/9.3AS/lib/libmemcached.so 4) Please install below

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.

Internals of PostgreSQLSrinivas MaddaliWhen we discuss internals of PostgreSQL we need to discuss about:a. Shared memory usage by the PostgreSQLb. Usage of the sub-systems by the PostgreSQL instancec. Other memory usage fori. Semaphoresii. Light-waited locksiii. Shared and exclusive locksiv. Checkpointingv. Auto vacuumvi. Save-point.vii. Commit Shared Memory purpose is to meet