Posts

Showing posts from April, 2020

PostgreSQL Point In Time Recovery (PITR)

need: one last basebackup and also enable archive before basebackup how to setup basebackup step1: edit pg_hba.conf and postgresql.conf file goto data directory vi pg_hba.conf # TYPE  DATABASE        USER            ADDRESS                 METHOD # "local" is for Unix domain socket connections only local   all             all                                     peer # IPv4 local connections: host    all             all           ...