Purging wall files with pg_archivecleanup in VC Appliance. Essentially, this is similar to "rm" except, it detects dependency of WAL files and subsequent WAL files. The following -n flag provide information of what else to be removed if WAL file 0000000100000002000000EA is removed. Note: watch out for space right after pg_xlogAnother example of deletion on different WAL file. The WAL file of 0000000100000002000000E6 will no longer in pg_xlog once deleted.root@photon-machine [ /storage/db/vpostgres/pg_xlog ]# /opt/vmware/vpostgres/9.6/bin/pg_archivecleanup -n /storage/db/vpostgres/pg_xlog/ 0000000100000002000000EA /storage/db/vpostgres/pg_xlog//0000000100000002000000E6 /storage/db/vpostgres/pg_xlog//0000000100000002000000E9 /storage/db/vpostgres/pg_xlog//0000000100000002000000E8 /storage/db/vpostgres/pg_xlog//0000000100000002000000E7
root@photon-machine [ /storage/db/vpostgres/pg_xlog ]# /opt/vmware/vpostgres/9.6/bin/pg_archivecleanup -d /storage/db/vpostgres/pg_xlog/ 0000000100000002000000E7 pg_archivecleanup: keep WAL file "/storage/db/vpostgres/pg_xlog//0000000100000002000000E7" and later pg_archivecleanup: removing file "/storage/db/vpostgres/pg_xlog//0000000100000002000000E6"
Friday, January 17, 2020
postgresql: Purging WAL files with pg_archivecleanup in VC Appliance.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment