Mindblown: a blog about philosophy.

[Book “Learn PostgreSQL”] Postgres stores configuration across several files – posgresql.conf, postgressql.auto.conf and pg_hba.conf. You can extend settings with additional configuration files, this allows to organize settings by topic – use include_file, include_dir or include_if_exists directives. You can inspect settings using SHOW command or by querying pg_setting catalog.Each configuration belongs to a context which defines…

[Book “Learn PostgreSQL”] I completed the chapter about physical backups. They are performed by coping PGDATA, tablespaces and WALs to another machine or different directory. You can leverage a buid-in postgres command pg_basebackup or 3rd party tool pgBackRest. Physical backups require careful approach to configuration e.g. connections values and hba rules. Point in time recovery is…

Postgres is equipped in three tools designated to handle logical backups: pg_dump, pg_dumpall and pg_restore. They offer rich customization for text and binary backups that can copy selected database objects. Dumping and restoring database can be performed by parallel workers to decrease operation time. The COPY and the native Postgres \copy commands allow integrating backup…

Backup & Restoration – Postgres supports two types of backups – logical and physical. Logical backup copies table by table as if any client performing series of SELECT statements. It is a reliable and simple method that works across major versions. However it takes more time and puts additional cpu and memory strain on the…