Advertising:
Depurar de Postgres el FS de Wals: Difference between revisions
Jump to navigation
Jump to search
(Created page with "==Loguearnos como Postgres y cargar entorno== [root@zbxssoo01 ~]# su - postgres [postgres@zbxssoo01 ~]$ pg12 Environment Postgres 12 cargado! ==Recuperar el ultimo Wal gen...") |
No edit summary |
||
Line 3: | Line 3: | ||
[postgres@zbxssoo01 ~]$ pg12 | [postgres@zbxssoo01 ~]$ pg12 | ||
Environment Postgres 12 cargado! | Environment Postgres 12 cargado! | ||
==Forzamos un Checkpoint== | |||
[postgres@zbxssoo01 ~]$ psql –d postgres | |||
checkpoint; | |||
==Recuperar el ultimo Wal generado== | ==Recuperar el ultimo Wal generado== |
Latest revision as of 11:15, 2 July 2020
Loguearnos como Postgres y cargar entorno
[root@zbxssoo01 ~]# su - postgres [postgres@zbxssoo01 ~]$ pg12 Environment Postgres 12 cargado!
Forzamos un Checkpoint
[postgres@zbxssoo01 ~]$ psql –d postgres checkpoint;
Recuperar el ultimo Wal generado
[postgres@zbxssoo01 pg_wal]$ pg_controldata -D $PGDATA pg_control version number: 1201 Catalog version number: 201909212 Database system identifier: 6831258203631478219 Database cluster state: in production pg_control last modified: Thu 02 Jul 2020 01:02:57 PM CEST Latest checkpoint location: 83DA/F10E8288 Latest checkpoint's REDO location: 83DA/D9503068 Latest checkpoint's REDO WAL file: 00000001000083DA000000D9 <--- Ultimo checkpoint
Verificar los wals que se va a cargar
[postgres@zbxssoo01 pg_wal]$ pg_archivecleanup -n $PGDATA/pg_wal/ 00000001000083DA000000D9
Eliminar los Wals
[postgres@zbxssoo01 pg_wal]$ pg_archivecleanup -d $PGDATA/pg_wal/ 00000001000083DA000000D9