วีดีโอ

Basic concepts of monitoring. What need to be monitored in postgres. What level monitoring has to be done.

Bloat in postgresql. How to remove bloat. Vacuum full command purpose.

Autovacuum in Postgresql. Important parameters for autovacuum background process.

Memory parameters in postgres and values to set.

Installing the postgres from source code. Build from source option. Custom installation. Customizing the postgres parameters during installation. Changing the default behavior of postgres during installation.

Various replication options in postgres warm standby and streaming replication . Hot standby concept.

pg_basebackup utility demo for taking the hot backup of the cluster.

basic maintenance activities in postgres . vacuum, analyze , reindex.

Cold and hot backup /restore in postgres

backup and restore options in postgres ( pg_dump, pg_dumpall , psql, pg_restore) with examples.

pgpass file demo in postgres. Password file concept. Password file description and demo of it.

Description of folder layout and OID in postgres.

tablespace concept in postgres

Concept of schema in postgres. How to create a new schema. How to create objects in new schema.

user creation in postgres

roles and privileges in postgres

postgresql conf demo

pg hba conf demo

background process in postgres

system catalog tables

postgres architecture overview

psql interface commands

connecting to cluster

pg ctl for starting stopping cluster

creating clusters in postgres

postgresql 10 installation using EDB software

postgres download options