archive-log Archives

postgres: what is the archive_command and when to use it

By adminPosted on September 11, 2022

Question : I have a master/slave postgresql configuration where the slave is a hot standby and is used as a […]

By adminPosted on September 10, 2022

Question : I have replication with PostgreSQL, so I want to set archive_command = ‘cp %p /var/lib/postgresql/11/main/archive/%f’ but I also […]

By adminPosted on June 6, 2022

Question : I have a production DB PostgreSQL 9.6 that is on master/standby structure. Every at 1 AM I restore […]

By adminPosted on May 19, 2022

Question : I recently spotted 3 very old archivelog directories on disk that do not appear within RMAN. [oracle@ORACLE01 archivelog]$ […]

By adminPosted on February 17, 2022

Question : I’m relatively new to PostgreSQL administration and I’m attempting to pick up the nitty gritty details as I […]

By adminPosted on February 4, 2022

Question : I have configured archive_timeout = 5 (i.e. 5 seconds) for a PostgreSQL 9.6 database in order to conduct […]

By adminPosted on October 29, 2021

Question : My main concern is knowing if the Oracle Archive Logs haven’t been backed up in a while because […]

By adminPosted on September 30, 2021

Question : I am having an issue “resetting” or fixing a backup server I have in BARMAN: -bash-4.2$ barman check […]

By adminPosted on August 3, 2021

Question : It’s required to update columns with metadata globally in all rows of all tables in DB. Let’s say […]

By adminPosted on May 22, 2021

Question : I got one main server and other two servers are replicating from the main. I got full disk […]