Postgres Archivelog
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
#!/bin/bash DEST=/backup/postgres/ ARCH=/data/pg_archive/ DD=$( date +%Y%m%d%H%M ) ## backup fisico del database pg_basebackup -D ${DEST}/fisico_${DD} -Ft -z -P pg_archivecleanup ${ARCH} $( ls -1t ${ARCH} | head -1 )