Hello all!
We are in the middle of Proof of concept Postgre backup implementation process.
No one of our backup team does have any experience regarding this backup type.
So far we do have implemented backup that I am able to see those two Backups sets:
I am trying to understand the difference between those two subclients. They were configured automatically.
I have found this in documentation:
So in case that we would like to do Full Backup of All DBs i should use Dump Based Backup?
But when creating backup for this subclient (Dump Based Backup)backup size is about 250mb… DB team checked server configuration and it said that DB is more then 3GB:
Why there is such a difference in sizes? It was very first backup so i can not blame deduplication or so…
While trying to use other sublient FSBasedBackupSet I am having a error with log directory.
This DB is not set to use any archive mode, so its in some kind of “simple recovery mode” and its not generating logs file.
So my questions are:
Why there is such a size difference?
Which subclient should be used to do Full Backups of All dbs on this server?
Do i need to use both subclients to have consistent full backup of DB?
Do i use one sublient for DBs with archivelog and other for the one with no archivelog configured?
