Postgres Archivelog: differenze tra le versioni
Jump to navigation
Jump to search
(Creata pagina con " 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...") |
Nessun oggetto della modifica |
||
Riga 8: | Riga 8: | ||
alter system set archive_command = 'test ! -f /data/pg_archive/%f && cp %p /data/pg_archive/%f' ; |
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= |
|||
Versione delle 15:52, 22 mar 2022
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