Postgres Archivelog - Cronologia

WikiSysop: /* gestione archivelog */

2022-03-22T17:10:42Z

gestione archivelog

← Versione meno recente		Versione delle 17:10, 22 mar 2022
Riga 17:		Riga 17:


			#!/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 )

	[[Categoria:Database]]		[[Categoria:Database]]

WikiSysop il 13:52, 22 mar 2022

2022-03-22T13:52:21Z

← Versione meno recente		Versione delle 13:52, 22 mar 2022
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=

WikiSysop: 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..."

2022-03-22T12:16:57Z

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..."

Nuova pagina

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' ;

[[Categoria:Database]]
[[Categoria:Postgres]]