When trying to run pg_basebackup I received the following error message: pg_basebackup: could not set compression level -1 (null) using the -z option. I received a similar error message when trying ...
I have a database with full backup of almost 2GB. When I perform a full backup (without compression) and then compress it with winrar it become 140MB, but when I backup WITH COMPRESSION syntax the ...
Is it possible to compress a backup file to .zip (or another) in a stored procedure invoked from a maintenance plan? My maintenance plan contains these steps: check DB (consistency, re_index, maybe ...
Currently, I am investigating some way to more efficiently backup 4 Production SQL Databases (3 different servers/instances) and would like to know if anyone else has had the problems we are having ...
I noticed that simply zipping my backup files reduces the space used by 70% My idea was to, initially, backup the databases to a local server; then, using Bacula or Cobian (I don't have a budget), ...