Dark Light
Reddit Scout Logo

Reddit Scout

Discover reviews on "database tar gz" based on Reddit discussions and experiences.

Last updated: February 19, 2025 at 03:32 AM
Go Back

Summary of Reddit Comments for "database tar gz"

PostgreSQL Backup and Restore Options

  • Running [pg_dump](https://www.amazon.com/Roll-Up-Folding-Tactical-Drawstring-Magazine/dp/B07K89DPV3/ref=sr_1_1?dib=eyJ2IjoiMSJ9.hV_tog1krKxEIBPLXNF3HOTbf8Vb4i_gPaFUIKbNEJDZWsyiAF6exhNUa8mTabssya6GGGnoi0KpGqz4BXMiCw.o0S2qhwLMcAYG7KODhIsFSUCvFUkWYbQtih9dh88VBc&dib_tag=se&keywords=pg_dump&qid=1739935926&sr=8-1&tag=redditrevie08-20) with gzip compression can tax CPU, especially at -9 compression level.
  • Using pg_backup to backup to a directory for multithreaded backups, compressing with [pigz](https://www.amazon.com/Manna-Pro-Farmhouse-Favorites-Flavored/dp/B0CQN3PC55/ref=sr_1_1?dib=eyJ2IjoiMSJ9.KlgoEr6GRzW7CDvhIEL_OTEjP63_cttbzIJbcz4tX4BpWKP7EVWUxkfHqPzAJhZhZJ9nWAgt0Ra3uizvnLMp0cmSHxWgF7BPqA2czpxV8UQ0Ce8kpNp_aJGYnWIs50C4t6cADQZNuVFIEgwEpxBl0KHcPgHixX8[xz](https://www.amazon.com/Breathable-Durable-Sleepers-Pillowcases-Natural/dp/B09KXLMB33/ref=sr_1_1?dib=eyJ2IjoiMSJ9.cdqqn9D3azogU_wdw4V8OSZ-VR8ERLILC5_piYOtOVdHZEN7uxVgcTxhmmEgGKmd-mw7n1tbtKBvHKbO9ek-19KUTPXbFbxHJvkemaMkeFP96gHLKhso_T_nuOGpT7qo5xLSntynmCOqwuzv7Kz0aXmstKzJBGjFk4TtOu6OoTf4j4nD8DVv-fZOjqsbJLuKaE4kIKhOOETDUgGSb67BBTuLG5F4W3xiswBuxSaGwh2LcT3M2T5I-woz5mtn0bzIZjt2zOmnv-oYZdGmLRtdO9oa9ikgDcRuZp7ikbCSUj4.0LkP1Ob3dzRp_Cut5fRDTgnPnsK65meTsEOjJvc2Xzg&dib_tag=se&keywords=xz&qid=1739935931&sr=8-1&tag=redditrevie08-20)tu7X30fAIuKwN4TvYnvViMHYsQPPdXgo2RIHQh9o6HIDn7O6D54bj34dECR44R-T_5201GKSgnzKjzLsaPa9x4HpuWcnsd8lYEiT2B369EMUENZHI9oe6ebcLE6CjEU-yZc9k4doU0.tELc7gDR1XkOdhbzwxJdDN_FK6sSbqIekvuYvmOWNJI&dib_tag=se&keywords=pigz&qid=1739935929&sr=8-1&tag=redditrevie08-20) into a [tar](https://www.amazon.com/T%C3%A1r-4K-UHD-Blu-ray-Digital/dp/B0BGVYNJKP/ref=sr_1_1?dib=eyJ2IjoiMSJ9.R90aBnSB7IpufiIybjFd5sJtuq2pjaOqihK-zr8ZsMRwTffkZiRXq94kvG9Xf6dQRjHMNXtqKXk26ii-6WWkfQ-TVthQCg-Vg66D0y1qOBlCWqjS2UOrl1JigVDVppsgACQrYYfrwderX7XicsN0vLfPSxEN2oMGpzyFn_8G1bFWrDBM_6YOAsQqtLBaRkxnNHZtlq9FgjI6PxpP-gjb_hFUb8nP9N7wjNgBiXfHRKM.9N0aB-vBqelc-YzUrJk4p2f71s4heL7UtA0GbEIFbrM&dib_tag=se&keywords=tar&qid=1739935927&sr=8-1&tag=redditrevie08-20).gz archive.
  • Directory backup allows for multithreaded backups and restores, crucial for RTO/PTO requirements.
  • Consider using --format=custom instead of a directory for a single compressed file backup.

Compression Options for Database Backups

  • Option 3 ([[zstd](https://www.amazon.com/JHSLXD-ZSTD-Ceramic-Restaurant-Decoration-Lampshade/dp/B082ZCQBB5/ref=sr_1_1?dib=eyJ2IjoiMSJ9.sy27tGSzfcQhyr4HghK1mZ82oTDyDcq3ePbGJg6oVozbFOEq5XVX559_Bbtmwdme6jDGE21z8XnNKYX1va0a-Y9e51R78-ZPz33SI32iK-jhoAoPSizDytbuBMwrNRFpnqRQEDHCfp5gxUFqM-Zeb40CYU1TBhXlaP1PVd8CipJMwGJNWIjBWJudnmYEwjF70f_8BBNVlLFC9Sl4qaozOf2X-Q1kSZJs6Ae4XInOduIFduKQd_L6bJq5AH2A2m8aNN23xjgn68VU7NdX1IDvn_YsR_o50_T0eEEv3ue6bpw.cgFGEtyZ_nF65ESgZ7uSNoFEpdwI6AmwCDKiP14awfE&dib_tag=se&keywords=zstd&qid=1739935926&sr=8-1&tag=redditrevie08-20)](https://www.amazon.com/JHSLXD-[zstd](https://www.amazon.com/JHSLXD-ZSTD-Ceramic-Restaurant-Decoration-Lampshade/dp/B082ZCQBB5/ref=sr_1_1?dib=eyJ2IjoiMSJ9.sy27tGSzfcQhyr4HghK1mZ82oTDyDcq3ePbGJg6oVozbFOEq5XVX559_Bbtmwdme6jDGE21z8XnNKYX1va0a-Y9e51R78-ZPz33SI32iK-jhoAoPSizDytbuBMwrNRFpnqRQEDHCfp5gxUFqM-Zeb40CYU1TBhXlaP1PVd8CipJMwGJNWIjBWJudnmYEwjF70f_8BBNVlLFC9Sl4qaozOf2X-Q1kSZJs6Ae4XInOduIFduKQd_L6bJq5AH2A2m8aNN23xjgn68VU7NdX1IDvn_YsR_o50_T0eEEv3ue6bpw.cgFGEtyZ_nF65ESgZ7uSNoFEpdwI6AmwCDKiP14awfE&dib_tag=se&keywords=zstd&qid=1739935926&sr=8-1&tag=redditrevie08-20)-Ceramic-Restaurant-Decoration-Lampshade/dp/B082ZCQBB5/ref=sr_1_1?dib=eyJ2IjoiMSJ9.sy27tGSzfcQhyr4HghK1mZ82oTDyDcq3ePbGJg6oVoxE_Dfo0Pj2xMejl7UFVQyCiLgVA8KydOzlDoix07VefrmJiiW1LHlvwjdCo_DidoXhoAoPSizDytbuBMwrNRFpnqRQEDHCfp5gxUFqM-Zeb40CYU1TBhXlaP1PVd8CipJMwGJNWIjBWJudnmYEwjF70f_8BBNVlLFC9Sl4qaozOf2X-Q1kSZJs6Ae4XInOduIFduKQd_L6bJq5AH2A2m8aNN23xjgn68VU7NdX1IDvn_YsR_o50_T0eEEv3ue6bpw.9FiXOC1RVMsXwfQUf3JzZUERpWRxns3uEgEnI_R3jFI&dib_tag=se&keywords=[zstd](https://www.amazon.com/JHSLXD-ZSTD-Ceramic-Restaurant-Decoration-Lampshade/dp/B082ZCQBB5/ref=sr_1_1?dib=eyJ2IjoiMSJ9.sy27tGSzfcQhyr4HghK1mZ82oTDyDcq3ePbGJg6oVozbFOEq5XVX559_Bbtmwdme6jDGE21z8XnNKYX1va0a-Y9e51R78-ZPz33SI32iK-jhoAoPSizDytbuBMwrNRFpnqRQEDHCfp5gxUFqM-Zeb40CYU1TBhXlaP1PVd8CipJMwGJNWIjBWJudnmYEwjF70f_8BBNVlLFC9Sl4qaozOf2X-Q1kSZJs6Ae4XInOduIFduKQd_L6bJq5AH2A2m8aNN23xjgn68VU7NdX1IDvn_YsR_o50_T0eEEv3ue6bpw.cgFGEtyZ_nF65ESgZ7uSNoFEpdwI6AmwCDKiP14awfE&dib_tag=se&keywords=zstd&qid=1739935926&sr=8-1&tag=redditrevie08-20)&qid=1739935926&sr=8-1&tag=redditrevie08-20)) provides the smallest file size, while .[tar](https://www.amazon.com/T%C3%A1r-4K-UHD-Blu-ray-Digital/dp/B0BGVYNJKP/ref=sr_1_1?dib=eyJ2IjoiMSJ9.R90aBnSB7IpufiIybjFd5sJtuq2pjaOqihK-zr8ZsMRwTffkZiRXq94kvG9Xf6dQRjHMNXtqKXk26ii-6WWkfQ-TVthQCg-Vg66D0y1qOBlCWqjS2UOrl1JigVDVppsgACQrYYfrwderX7XicsN0vLfPSxEN2oMGpzyFn_8G1bFWrDBM_6YOAsQqtLBaRkxnNHZtlq9FgjI6PxpP-gjb_hFUb8nP9N7wjNgBiXfHRKM.9N0aB-vBqelc-YzUrJk4p2f71s4heL7UtA0GbEIFbrM&dib_tag=se&keywords=tar&qid=1739935927&sr=8-1&tag=redditrevie08-20).[xz](https://www.amazon.com/Breathable-Durable-Sleepers-Pillowcases-Natural/dp/B09KXLMB33/ref=sr_1_1?dib=eyJ2IjoiMSJ9.cdqqn9D3azogU_wdw4V8OSZ-VR8ERLILC5_piYOtOVdHZEN7uxVgcTxhmmEgGKmd-mw7n1tbtKBvHKbO9ek-19KUTPXbFbxHJvkemaMkeFP96gHLKhso_T_nuOGpT7qo5xLSntynmCOqwuzv7Kz0aXmstKzJBGjFk4TtOu6OoTf4j4nD8DVv-fZOjqsbJLuKaE4kIKhOOETDUgGSb67BBTuLG5F4W3xiswBuxSaGwh2LcT3M2T5I-woz5mtn0bzIZjt2zOmnv-oYZdGmLRtdO9oa9ikgDcRuZp7ikbCSUj4.0LkP1Ob3dzRp_Cut5fRDTgnPnsK65meTsEOjJvc2Xzg&dib_tag=se&keywords=xz&qid=1739935931&sr=8-1&tag=redditrevie08-20) offers even smaller compression.
  • [7-zip](https://www.amazon.com/YaHoGa-Separating-Jacket-Zippers-Plastic/dp/B0[7z](https://www.amazon.com/Sure-Regular-Original-Anti-Perspirant-Deodorant/dp/B001E8E7GK/ref=sr_1_1?dib=eyJ2IjoiMSJ9.SXEOVekFzyGfHqYO0oFd9ApvHQgTBZR3Vw7NMq6zEodNhB4Rm5C-840rpscuWzrPpAbz1sYyxR9ZkKODUoOhI3noM7J6XnDlhar4FwfbAsjlj8jGdBsaOZ14r1ZbWQisz9ZurR-v4Qsa457Q31WsfUaKRJ0DSta-Blm0n3NCFvxXAE5cKT4E2hEh0VKanzNQmXXQ6TiXd8UiwA-Mv_Te4F-OR_ZhuTeFm2aZ7AO7DJ5VSl93bmx4xrwuPahmgllssbNEsvupgMo9dwplT9ydRWExj7LJ0pObuA6bqgEI6j8.o0MAoZZa_LDR6lX16vjDvirdVNG2GCLY9-XMZDvyn2U&dib_tag=se&keywords=7z&qid=1739935934&sr=8-1&tag=redditrevie08-20)FZ1963/ref=sr_1_1?dib=eyJ2IjoiMSJ9.ZT7JAvKygL6sKSu1Jf3-MODkBSH_366OHvRewvLywFjJ-DznpTkVcueun5_1l1cYoPg7C4KoKpiAYe2cvTWUd0GnttqZs8F1ZpP_hBuqAsEnu0JKTAMeRD-IEJZq8_a22ecenWKq2ex8Lt1AI3J-mfQrX4Rplf2B1IqQpFUDdV-VKjuT6uWMPhG98R7MGUGx9vQqu1lMYehE_rg4X5zYHi4N-XBh-HUF7R_eJiG4bcGlL8s5asbLiu71qk-cu491t2mlGnv3Us5PuWOLWd64s_CxwaIcudWmH5PcncP4z58.oCzL1ohAR0-stNBX_fKPy3NJEA9NsW9JqQDuJp02i5Y&dib_tag=se&keywords=7-zip&qid=1739935935&sr=8-1&tag=redditrevie08-20) offers better compression in solid mode, but may result in slower extraction times.
  • zpaq is recommended for long-term storage for its efficient compression.
  • [tar](https://www.amazon.com/T%C3%A1r-4K-UHD-Blu-ray-Digital/dp/B0BGVYNJKP/ref=sr_1_1?dib=eyJ2IjoiMSJ9.R90aBnSB7IpufiIybjFd5sJtuq2pjaOqihK-zr8ZsMRwTffkZiRXq94kvG9Xf6dQRjHMNXtqKXk26ii-6WWkfQ-TVthQCg-Vg66D0y1qOBlCWqjS2UOrl1JigVDVppsgACQrYYfrwderX7XicsN0vLfPSxEN2oMGpzyFn_8G1bFWrDBM_6YOAsQqtLBaRkxnNHZtlq9FgjI6PxpP-gjb_hFUb8nP9N7wjNgBiXfHRKM.9N0aB-vBqelc-YzUrJk4p2f71s4heL7UtA0GbEIFbrM&dib_tag=se&keywords=tar&qid=1739935927&sr=8-1&tag=redditrevie08-20) format is criticized for producing redundant data in headers compared to [7z](https://www.amazon.com/Sure-Regular-Original-Anti-Perspirant-Deodorant/dp/B001E8E7GK/ref=sr_1_1?dib=eyJ2IjoiMSJ9.SXEOVekFzyGfHqYO0oFd9ApvHQgTBZR3Vw7NMq6zEodNhB4Rm5C-840rpscuWzrPpAbz1sYyxR9ZkKODUoOhI3noM7J6XnDlhar4FwfbAsjlj8jGdBsaOZ14r1ZbWQisz9ZurR-v4Qsa457Q31WsfUaKRJ0DSta-Blm0n3NCFvxXAE5cKT4E2hEh0VKanzNQmXXQ6TiXd8UiwA-Mv_Te4F-OR_ZhuTeFm2aZ7AO7DJ5VSl93bmx4xrwuPahmgllssbNEsvupgMo9dwplT9ydRWExj7LJ0pObuA6bqgEI6j8.o0MAoZZa_LDR6lX16vjDvirdVNG2GCLY9-XMZDvyn2U&dib_tag=se&keywords=7z&qid=1739935934&sr=8-1&tag=redditrevie08-20) or zpaq.

Considerations for Compression Algorithms

  • [[zstd](https://www.amazon.com/JHSLXD-ZSTD-Ceramic-Restaurant-Decoration-Lampshade/dp/B082ZCQBB5/ref=sr_1_1?dib=eyJ2IjoiMSJ9.sy27tGSzfcQhyr4HghK1mZ82oTDyDcq3ePbGJg6oVozbFOEq5XVX559_Bbtmwdme6jDGE21z8XnNKYX1va0a-Y9e51R78-ZPz33SI32iK-jhoAoPSizDytbuBMwrNRFpnqRQEDHCfp5gxUFqM-Zeb40CYU1TBhXlaP1PVd8CipJMwGJNWIjBWJudnmYEwjF70f_8BBNVlLFC9Sl4qaozOf2X-Q1kSZJs6Ae4XInOduIFduKQd_L6bJq5AH2A2m8aNN23xjgn68VU7NdX1IDvn_YsR_o50_T0eEEv3ue6bpw.cgFGEtyZ_nF65ESgZ7uSNoFEpdwI6AmwCDKiP14awfE&dib_tag=se&keywords=zstd&qid=1739935926&sr=8-1&tag=redditrevie08-20)](https://www.amazon.com/JHSLXD-[zstd](https://www.amazon.com/JHSLXD-ZSTD-Ceramic-Restaurant-Decoration-Lampshade/dp/B082ZCQBB5/ref=sr_1_1?dib=eyJ2IjoiMSJ9.sy27tGSzfcQhyr4HghK1mZ82oTDyDcq3ePbGJg6oVozbFOEq5XVX559_Bbtmwdme6jDGE21z8XnNKYX1va0a-Y9e51R78-ZPz33SI32iK-jhoAoPSizDytbuBMwrNRFpnqRQEDHCfp5gxUFqM-Zeb40CYU1TBhXlaP1PVd8CipJMwGJNWIjBWJudnmYEwjF70f_8BBNVlLFC9Sl4qaozOf2X-Q1kSZJs6Ae4XInOduIFduKQd_L6bJq5AH2A2m8aNN23xjgn68VU7NdX1IDvn_YsR_o50_T0eEEv3ue6bpw.cgFGEtyZ_nF65ESgZ7uSNoFEpdwI6AmwCDKiP14awfE&dib_tag=se&keywords=zstd&qid=1739935926&sr=8-1&tag=redditrevie08-20)-Ceramic-Restaurant-Decoration-Lampshade/dp/B082ZCQBB5/ref=sr_1_1?dib=eyJ2IjoiMSJ9.sy27tGSzfcQhyr4HghK1mZ82oTDyDcq3ePbGJg6oVoxE_Dfo0Pj2xMejl7UFVQyCiLgVA8KydOzlDoix07VefrmJiiW1LHlvwjdCo_DidoXhoAoPSizDytbuBMwrNRFpnqRQEDHCfp5gxUFqM-Zeb40CYU1TBhXlaP1PVd8CipJMwGJNWIjBWJudnmYEwjF70f_8BBNVlLFC9Sl4qaozOf2X-Q1kSZJs6Ae4XInOduIFduKQd_L6bJq5AH2A2m8aNN23xjgn68VU7NdX1IDvn_YsR_o50_T0eEEv3ue6bpw.9FiXOC1RVMsXwfQUf3JzZUERpWRxns3uEgEnI_R3jFI&dib_tag=se&keywords=[zstd](https://www.amazon.com/JHSLXD-ZSTD-Ceramic-Restaurant-Decoration-Lampshade/dp/B082ZCQBB5/ref=sr_1_1?dib=eyJ2IjoiMSJ9.sy27tGSzfcQhyr4HghK1mZ82oTDyDcq3ePbGJg6oVozbFOEq5XVX559_Bbtmwdme6jDGE21z8XnNKYX1va0a-Y9e51R78-ZPz33SI32iK-jhoAoPSizDytbuBMwrNRFpnqRQEDHCfp5gxUFqM-Zeb40CYU1TBhXlaP1PVd8CipJMwGJNWIjBWJudnmYEwjF70f_8BBNVlLFC9Sl4qaozOf2X-Q1kSZJs6Ae4XInOduIFduKQd_L6bJq5AH2A2m8aNN23xjgn68VU7NdX1IDvn_YsR_o50_T0eEEv3ue6bpw.cgFGEtyZ_nF65ESgZ7uSNoFEpdwI6AmwCDKiP14awfE&dib_tag=se&keywords=zstd&qid=1739935926&sr=8-1&tag=redditrevie08-20)&qid=1739935926&sr=8-1&tag=redditrevie08-20) is recommended for unknown data types, while [xz](https://www.amazon.com/Breathable-Durable-Sleepers-Pillowcases-Natural/dp/B09KXLMB33/ref=sr_1_1?dib=eyJ2IjoiMSJ9.cdqqn9D3azogU_wdw4V8OSZ-VR8ERLILC5_piYOtOVdHZEN7uxVgcTxhmmEgGKmd-mw7n1tbtKBvHKbO9ek-19KUTPXbFbxHJvkemaMkeFP96gHLKhso_T_nuOGpT7qo5xLSntynmCOqwuzv7Kz0aXmstKzJBGjFk4TtOu6OoTf4j4nD8DVv-fZOjqsbJLuKaE4kIKhOOETDUgGSb67BBTuLG5F4W3xiswBuxSaGwh2LcT3M2T5I-woz5mtn0bzIZjt2zOmnv-oYZdGmLRtdO9oa9ikgDcRuZp7ikbCSUj4.0LkP1Ob3dzRp_Cut5fRDTgnPnsK65meTsEOjJvc2Xzg&dib_tag=se&keywords=xz&qid=1739935931&sr=8-1&tag=redditrevie08-20) or gzip/[pigz](https://www.amazon.com/Manna-Pro-Farmhouse-Favorites-Flavored/dp/B0CQN3PC55/ref=sr_1_1?dib=eyJ2IjoiMSJ9.KlgoEr6GRzW7CDvhIEL_OTEjP63_cttbzIJbcz4tX4BpWKP7EVWUxkfHqPzAJhZhZJ9nWAgt0Ra3uizvnLMp0cmSHxWgF7BPqA2czpxV8UQ0Ce8kpNp_aJGYnWIs50C4t6cADQZNuVFIEgwEpxBl0KHcPgHixX8[xz](https://www.amazon.com/Breathable-Durable-Sleepers-Pillowcases-Natural/dp/B09KXLMB33/ref=sr_1_1?dib=eyJ2IjoiMSJ9.cdqqn9D3azogU_wdw4V8OSZ-VR8ERLILC5_piYOtOVdHZEN7uxVgcTxhmmEgGKmd-mw7n1tbtKBvHKbO9ek-19KUTPXbFbxHJvkemaMkeFP96gHLKhso_T_nuOGpT7qo5xLSntynmCOqwuzv7Kz0aXmstKzJBGjFk4TtOu6OoTf4j4nD8DVv-fZOjqsbJLuKaE4kIKhOOETDUgGSb67BBTuLG5F4W3xiswBuxSaGwh2LcT3M2T5I-woz5mtn0bzIZjt2zOmnv-oYZdGmLRtdO9oa9ikgDcRuZp7ikbCSUj4.0LkP1Ob3dzRp_Cut5fRDTgnPnsK65meTsEOjJvc2Xzg&dib_tag=se&keywords=xz&qid=1739935931&sr=8-1&tag=redditrevie08-20)tu7X30fAIuKwN4TvYnvViMHYsQPPdXgo2RIHQh9o6HIDn7O6D54bj34dECR44R-T_5201GKSgnzKjzLsaPa9x4HpuWcnsd8lYEiT2B369EMUENZHI9oe6ebcLE6CjEU-yZc9k4doU0.tELc7gDR1XkOdhbzwxJdDN_FK6sSbqIekvuYvmOWNJI&dib_tag=se&keywords=pigz&qid=1739935929&sr=8-1&tag=redditrevie08-20) are suitable for mixed versions like RHEL5.
  • bzip2 is less efficient compared to [xz](https://www.amazon.com/Breathable-Durable-Sleepers-Pillowcases-Natural/dp/B09KXLMB33/ref=sr_1_1?dib=eyJ2IjoiMSJ9.cdqqn9D3azogU_wdw4V8OSZ-VR8ERLILC5_piYOtOVdHZEN7uxVgcTxhmmEgGKmd-mw7n1tbtKBvHKbO9ek-19KUTPXbFbxHJvkemaMkeFP96gHLKhso_T_nuOGpT7qo5xLSntynmCOqwuzv7Kz0aXmstKzJBGjFk4TtOu6OoTf4j4nD8DVv-fZOjqsbJLuKaE4kIKhOOETDUgGSb67BBTuLG5F4W3xiswBuxSaGwh2LcT3M2T5I-woz5mtn0bzIZjt2zOmnv-oYZdGmLRtdO9oa9ikgDcRuZp7ikbCSUj4.0LkP1Ob3dzRp_Cut5fRDTgnPnsK65meTsEOjJvc2Xzg&dib_tag=se&keywords=xz&qid=1739935931&sr=8-1&tag=redditrevie08-20), [[zstd](https://www.amazon.com/JHSLXD-ZSTD-Ceramic-Restaurant-Decoration-Lampshade/dp/B082ZCQBB5/ref=sr_1_1?dib=eyJ2IjoiMSJ9.sy27tGSzfcQhyr4HghK1mZ82oTDyDcq3ePbGJg6oVozbFOEq5XVX559_Bbtmwdme6jDGE21z8XnNKYX1va0a-Y9e51R78-ZPz33SI32iK-jhoAoPSizDytbuBMwrNRFpnqRQEDHCfp5gxUFqM-Zeb40CYU1TBhXlaP1PVd8CipJMwGJNWIjBWJudnmYEwjF70f_8BBNVlLFC9Sl4qaozOf2X-Q1kSZJs6Ae4XInOduIFduKQd_L6bJq5AH2A2m8aNN23xjgn68VU7NdX1IDvn_YsR_o50_T0eEEv3ue6bpw.cgFGEtyZ_nF65ESgZ7uSNoFEpdwI6AmwCDKiP14awfE&dib_tag=se&keywords=zstd&qid=1739935926&sr=8-1&tag=redditrevie08-20)](https://www.amazon.com/JHSLXD-[zstd](https://www.amazon.com/JHSLXD-ZSTD-Ceramic-Restaurant-Decoration-Lampshade/dp/B082ZCQBB5/ref=sr_1_1?dib=eyJ2IjoiMSJ9.sy27tGSzfcQhyr4HghK1mZ82oTDyDcq3ePbGJg6oVozbFOEq5XVX559_Bbtmwdme6jDGE21z8XnNKYX1va0a-Y9e51R78-ZPz33SI32iK-jhoAoPSizDytbuBMwrNRFpnqRQEDHCfp5gxUFqM-Zeb40CYU1TBhXlaP1PVd8CipJMwGJNWIjBWJudnmYEwjF70f_8BBNVlLFC9Sl4qaozOf2X-Q1kSZJs6Ae4XInOduIFduKQd_L6bJq5AH2A2m8aNN23xjgn68VU7NdX1IDvn_YsR_o50_T0eEEv3ue6bpw.cgFGEtyZ_nF65ESgZ7uSNoFEpdwI6AmwCDKiP14awfE&dib_tag=se&keywords=zstd&qid=1739935926&sr=8-1&tag=redditrevie08-20)-Ceramic-Restaurant-Decoration-Lampshade/dp/B082ZCQBB5/ref=sr_1_1?dib=eyJ2IjoiMSJ9.sy27tGSzfcQhyr4HghK1mZ82oTDyDcq3ePbGJg6oVoxE_Dfo0Pj2xMejl7UFVQyCiLgVA8KydOzlDoix07VefrmJiiW1LHlvwjdCo_DidoXhoAoPSizDytbuBMwrNRFpnqRQEDHCfp5gxUFqM-Zeb40CYU1TBhXlaP1PVd8CipJMwGJNWIjBWJudnmYEwjF70f_8BBNVlLFC9Sl4qaozOf2X-Q1kSZJs6Ae4XInOduIFduKQd_L6bJq5AH2A2m8aNN23xjgn68VU7NdX1IDvn_YsR_o50_T0eEEv3ue6bpw.9FiXOC1RVMsXwfQUf3JzZUERpWRxns3uEgEnI_R3jFI&dib_tag=se&keywords=[zstd](https://www.amazon.com/JHSLXD-ZSTD-Ceramic-Restaurant-Decoration-Lampshade/dp/B082ZCQBB5/ref=sr_1_1?dib=eyJ2IjoiMSJ9.sy27tGSzfcQhyr4HghK1mZ82oTDyDcq3ePbGJg6oVozbFOEq5XVX559_Bbtmwdme6jDGE21z8XnNKYX1va0a-Y9e51R78-ZPz33SI32iK-jhoAoPSizDytbuBMwrNRFpnqRQEDHCfp5gxUFqM-Zeb40CYU1TBhXlaP1PVd8CipJMwGJNWIjBWJudnmYEwjF70f_8BBNVlLFC9Sl4qaozOf2X-Q1kSZJs6Ae4XInOduIFduKQd_L6bJq5AH2A2m8aNN23xjgn68VU7NdX1IDvn_YsR_o50_T0eEEv3ue6bpw.cgFGEtyZ_nF65ESgZ7uSNoFEpdwI6AmwCDKiP14awfE&dib_tag=se&keywords=zstd&qid=1739935926&sr=8-1&tag=redditrevie08-20)&qid=1739935926&sr=8-1&tag=redditrevie08-20), or [7z](https://www.amazon.com/Sure-Regular-Original-Anti-Perspirant-Deodorant/dp/B001E8E7GK/ref=sr_1_1?dib=eyJ2IjoiMSJ9.SXEOVekFzyGfHqYO0oFd9ApvHQgTBZR3Vw7NMq6zEodNhB4Rm5C-840rpscuWzrPpAbz1sYyxR9ZkKODUoOhI3noM7J6XnDlhar4FwfbAsjlj8jGdBsaOZ14r1ZbWQisz9ZurR-v4Qsa457Q31WsfUaKRJ0DSta-Blm0n3NCFvxXAE5cKT4E2hEh0VKanzNQmXXQ6TiXd8UiwA-Mv_Te4F-OR_ZhuTeFm2aZ7AO7DJ5VSl93bmx4xrwuPahmgllssbNEsvupgMo9dwplT9ydRWExj7LJ0pObuA6bqgEI6j8.o0MAoZZa_LDR6lX16vjDvirdVNG2GCLY9-XMZDvyn2U&dib_tag=se&keywords=7z&qid=1739935934&sr=8-1&tag=redditrevie08-20)ip.
  • Test different algorithms to determine the best performance for the data.

Tools and Methods for Compression

  • Use pbzip2 and pi[xz](https://www.amazon.com/Breathable-Durable-Sleepers-Pillowcases-Natural/dp/B09KXLMB33/ref=sr_1_1?dib=eyJ2IjoiMSJ9.cdqqn9D3azogU_wdw4V8OSZ-VR8ERLILC5_piYOtOVdHZEN7uxVgcTxhmmEgGKmd-mw7n1tbtKBvHKbO9ek-19KUTPXbFbxHJvkemaMkeFP96gHLKhso_T_nuOGpT7qo5xLSntynmCOqwuzv7Kz0aXmstKzJBGjFk4TtOu6OoTf4j4nD8DVv-fZOjqsbJLuKaE4kIKhOOETDUgGSb67BBTuLG5F4W3xiswBuxSaGwh2LcT3M2T5I-woz5mtn0bzIZjt2zOmnv-oYZdGmLRtdO9oa9ikgDcRuZp7ikbCSUj4.0LkP1Ob3dzRp_Cut5fRDTgnPnsK65meTsEOjJvc2Xzg&dib_tag=se&keywords=xz&qid=1739935931&sr=8-1&tag=redditrevie08-20) for multi-thread compression alternatives to gzip.
  • brotli is efficient but lacks thread support.
  • lrzip offers high compression rates but is slow.
  • --[rsyncable](https://www.amazon.com/LANZYKU-Transmission-Control-Data-Right-angle13inches/dp/B0BWYNCSXQ/ref=sr_1_1?dib=eyJ2IjoiMSJ9.3Yyw3LglCIC174Kmvj9EUg.tJCTMMDrSwY3bDML7xbQ_b4EOax1yc0-R1CLFERcsqo&dib_tag=se&keywords=rsyncable&qid=1739935928&sr=8-1&tag=redditrevie08-20) option in gzip and [pigz](https://www.amazon.com/Manna-Pro-Farmhouse-Favorites-Flavored/dp/B0CQN3PC55/ref=sr_1_1?dib=eyJ2IjoiMSJ9.KlgoEr6GRzW7CDvhIEL_OTEjP63_cttbzIJbcz4tX4BpWKP7EVWUxkfHqPzAJhZhZJ9nWAgt0Ra3uizvnLMp0cmSHxWgF7BPqA2czpxV8UQ0Ce8kpNp_aJGYnWIs50C4t6cADQZNuVFIEgwEpxBl0KHcPgHixX8[xz](https://www.amazon.com/Breathable-Durable-Sleepers-Pillowcases-Natural/dp/B09KXLMB33/ref=sr_1_1?dib=eyJ2IjoiMSJ9.cdqqn9D3azogU_wdw4V8OSZ-VR8ERLILC5_piYOtOVdHZEN7uxVgcTxhmmEgGKmd-mw7n1tbtKBvHKbO9ek-19KUTPXbFbxHJvkemaMkeFP96gHLKhso_T_nuOGpT7qo5xLSntynmCOqwuzv7Kz0aXmstKzJBGjFk4TtOu6OoTf4j4nD8DVv-fZOjqsbJLuKaE4kIKhOOETDUgGSb67BBTuLG5F4W3xiswBuxSaGwh2LcT3M2T5I-woz5mtn0bzIZjt2zOmnv-oYZdGmLRtdO9oa9ikgDcRuZp7ikbCSUj4.0LkP1Ob3dzRp_Cut5fRDTgnPnsK65meTsEOjJvc2Xzg&dib_tag=se&keywords=xz&qid=1739935931&sr=8-1&tag=redditrevie08-20)tu7X30fAIuKwN4TvYnvViMHYsQPPdXgo2RIHQh9o6HIDn7O6D54bj34dECR44R-T_5201GKSgnzKjzLsaPa9x4HpuWcnsd8lYEiT2B369EMUENZHI9oe6ebcLE6CjEU-yZc9k4doU0.tELc7gDR1XkOdhbzwxJdDN_FK6sSbqIekvuYvmOWNJI&dib_tag=se&keywords=pigz&qid=1739935929&sr=8-1&tag=redditrevie08-20) aids in efficient file transfer.
  • p[xz](https://www.amazon.com/Breathable-Durable-Sleepers-Pillowcases-Natural/dp/B09KXLMB33/ref=sr_1_1?dib=eyJ2IjoiMSJ9.cdqqn9D3azogU_wdw4V8OSZ-VR8ERLILC5_piYOtOVdHZEN7uxVgcTxhmmEgGKmd-mw7n1tbtKBvHKbO9ek-19KUTPXbFbxHJvkemaMkeFP96gHLKhso_T_nuOGpT7qo5xLSntynmCOqwuzv7Kz0aXmstKzJBGjFk4TtOu6OoTf4j4nD8DVv-fZOjqsbJLuKaE4kIKhOOETDUgGSb67BBTuLG5F4W3xiswBuxSaGwh2LcT3M2T5I-woz5mtn0bzIZjt2zOmnv-oYZdGmLRtdO9oa9ikgDcRuZp7ikbCSUj4.0LkP1Ob3dzRp_Cut5fRDTgnPnsK65meTsEOjJvc2Xzg&dib_tag=se&keywords=xz&qid=1739935931&sr=8-1&tag=redditrevie08-20) and [lz4](https://www.amazon.com/1PZ-Quadsport-2003-2007-1998-2002-2000-2001/dp/B07GDD4XMD/ref=sr_1_1?dib=eyJ2IjoiMSJ9.pbHRMtFMijIE6St42ju_U0zkm5n1lZ89pUWZXOjuS4vT1xummXr9d66Sq0LG8mcnLq-6k7u0HUxq8bxcEH02Y3wQYFgSMO-sIYV1q3irTlxHGWseMXaGvk5DZbyCuPbV0caEPK5-wWZ91Di6bpbJ4gMa07ipEPSWFU3ehNy3dQyaZrNrO26ZH-mMI_EHUCMamm0yRrtUSX95b5EqnWMuUsZVMnQv2dxrzU54ahTIUBxpVFwlLhoQv3JEvFv-pedXyJrd_D9foGmX1PPHd5MCu8ZKcQyYSH3kl-qC_7j73Yk.AwJOLi0mC-I0dUpjxKghqZ_i_c34WawM3MttnlMG3gE&dib_tag=se&keywords=lz4&qid=1739935927&sr=8-1&tag=redditrevie08-20) are recommended for various compression purposes.

Other Discussions Related to Compression

  • Using specific LZ implementations for data compression on different platforms.
  • LZ compression replaces repeating data with placeholders for efficient data storage.
  • Compression may not impact performance significantly, especially with [lz4](https://www.amazon.com/1PZ-Quadsport-2003-2007-1998-2002-2000-2001/dp/B07GDD4XMD/ref=sr_1_1?dib=eyJ2IjoiMSJ9.pbHRMtFMijIE6St42ju_U0zkm5n1lZ89pUWZXOjuS4vT1xummXr9d66Sq0LG8mcnLq-6k7u0HUxq8bxcEH02Y3wQYFgSMO-sIYV1q3irTlxHGWseMXaGvk5DZbyCuPbV0caEPK5-wWZ91Di6bpbJ4gMa07ipEPSWFU3ehNy3dQyaZrNrO26ZH-mMI_EHUCMamm0yRrtUSX95b5EqnWMuUsZVMnQv2dxrzU54ahTIUBxpVFwlLhoQv3JEvFv-pedXyJrd_D9foGmX1PPHd5MCu8ZKcQyYSH3kl-qC_7j73Yk.AwJOLi0mC-I0dUpjxKghqZ_i_c34WawM3MttnlMG3gE&dib_tag=se&keywords=lz4&qid=1739935927&sr=8-1&tag=redditrevie08-20) on Linux.
  • Consider load times and performance impact when compressing large files.
  • Validate results before and after compression to ensure effective space savings.

This summary provides insights on different compression methods, tools, and considerations for database backups and file compression based on Reddit comments related to the query "database tar gz."

Sitemap | Privacy Policy

Disclaimer: This website may contain affiliate links. As an Amazon Associate, I earn from qualifying purchases. This helps support the maintenance and development of this free tool.