This site uses cookies to deliver our services. By using our site, you acknowledge that you have read and understand our Cookie and Privacy Policy. Your use of IDimager Products and Services is subject to these policies.

Had major modification to do in folders structure and in Catalog Categories.
Once done I wanted to backup the catalog.
PSU hangs. Coloured circle appears. I let it as is overnight.
Next morning PSU is closed.
Disk free space: 885gb
I also upgraded to last version.

I tried pg tools, got errors.
Used pgdump command, worked ok.
Used pg_dumd; file was 380mb.
With pg_dumpall, file was 6.2 gb.

In a disaster scenario where I would loose my whole database, which version would be best to use to restore entire database?

Today, I tried PgAdmin 4.
New version is Web based.
First try, file was 99mb.
Second try I choose options, to the best of my understanding, options referring to data and tables. File increase to 700mb.
I then ran pg_dumpall: 13gb.

I may be storing useless information.
Would like to know best backup method.

If anyone would have a script for backing up automatically, I would sure appreciate it.