new pg server.md

new pg server

compilation

./configure \
--with-systemd \
--with-libxml \
--with-pam \
--with-system-tzdata=/usr/share/zoneinfo \
--with-uuid=e2fs \
--with-openssl \
--with-llvm LLVM_CONFIG='/usr/bin/llvm-config' \
--enable-thread-safety
make world
make check
sudo make install-world

migration db1 => db2

• pglogical_upgrade_demo

extensions

• pg_stat_kcache
• pg_qualstats
• pg_sortstats
• pgcluu
• pganalyze
• pgtop

settings

'pg_stat_statement,pg_stat_kcache,pg_qualstats,pg_sortstats,btree_gist,pg_buffercache'
track_io_timing = on
track_activities = on
track_activity_query_size = 10000
pg_stat_statements.track = all