Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Techies,
I have taken a qlik sense repository backup and size of the backup zip file is more than 15 GB. Now I can transfer so much large file because of its size, Can I split the backed up file in chunks and when I need to restore my Qlik Sense site I can club it back to its original form and use it to restore site.
Thanks in advance,
Rohit
Tools like 7zip for example can split up zip files in multiple parts.
Yes. Splitting up a zip file would be pretty useless if you can't put the files back together again.
If you like you can first do a md5 checksum on the file that pg_dump spits out and then check that later on the file you retrieve from the zip files. If they're the same then the file is the same and no bits were lost.
As @Gysbert_Wassenaar mentioned, most modern compression tools can do splitting (unfortunately the default zipping present in Windows does not). Using parity files (https://en.wikipedia.org/wiki/Parchive) to ensure that you can rebuild the final TAR would make sense.
Honestly, at a higher level, I don't see why a QSR database should be 15GB. What's the result of this query against the QSR:
SELECT schemaname,relname,n_live_tup FROM pg_stat_user_tables ORDER BY n_live_tup DESC;
?
I have not honestly used any tool for handling TAR files, so I cannot recommend anything specifically for the job. I personally use Bandzip for compression but any modern compression software (WinRAR, 7zip, etc) can handle the splitting. Historically, I like http://www.quickpar.org.uk/ for the parity piece.
I don't understand what you're doing. If you use pg_dump to create a backup file you get 1 big tar file. With 7zip you can zip that file and split the archive over multiple parts. All parts are necessary to recreate the original tar file. So why on earth do you put half of those parts in one folder and the other half in another folder? And then you do more weird stuff that's totally unclear to me.
And another thing did you use pg_dump to create a backup of only the QSR database or did you use pg_dumpall which creates a backup that contains all the databases including the QLogs database?