Postgres Archivelog

Da Emigar.
Jump to navigation Jump to search

https://www.postgresql.org/docs/14/continuous-archiving.html 

--
alter system set wal_level=replica;
alter system set archive_mode=on;
alter system set wal_compression=on;
alter system set archive_command = 'test ! -f /data/pg_archive/%f && cp %p /data/pg_archive/%f' ;


eseguire backup

https://www.postgresql.org/docs/current/app-pgbasebackup.html 

pg_basebackup -D /backup/postgres/fisico -Ft -z -P

gestione archivelog

Estratto da "http://www.emigar.com/wiki/index.php?title=Postgres_Archivelog&oldid=5924"