Question : I have a master/slave postgresql configuration where the slave is a hot standby and is used as a […]
Tag: archive-log
Difference between Archive destination & db_recovery_file_dest
Question : What is exact difference between Archive destination & db_recovery_file_dest on Oracle Database? SQL> show parameter reco NAME TYPE […]
postgres: what is the archive_command and when to use it
Question : I have a master/slave postgresql configuration where the slave is a hot standby and is used as a […]
multiple archive_command in PostgreSQL
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 […]
PostgreSQL 9.6, Disable archive log or minimal archive log size when do a pg_restore
Question : I have a production DB PostgreSQL 9.6 that is on master/standby structure. Every at 1 AM I restore […]
Old archivelog files present on disk, but not in RMAN
Question : I recently spotted 3 very old archivelog directories on disk that do not appear within RMAN. [oracle@ORACLE01 archivelog]$ […]
Does Postgres automatically rotate WAL files out (pg_xlog) if archive_mode is off?
Question : I’m relatively new to PostgreSQL administration and I’m attempting to pick up the nitty gritty details as I […]
File creation dates of archived WAL files not in line with archive_timeout in PostgreSQL 9.6
Question : I have configured archive_timeout = 5 (i.e. 5 seconds) for a PostgreSQL 9.6 database in order to conduct […]
How can I use RMAN to show if there are archive logs that need to backed up?
Question : My main concern is knowing if the Oracle Archive Logs haven’t been backed up in a while because […]
How do I stop WAL streaming in BARMAN cron?
Question : I am having an issue “resetting” or fixing a backup server I have in BARMAN: -bash-4.2$ barman check […]
- 1
- 2