Backup fails PSU quits

[rdv4rjm]

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.

Would anyone have suggestions?

Thanks in advance

[Hert]

Are you using Single or Server edition? If the latter, what database system?

[rdv4rjm]

I am using Server Edition
Postgres on Mac

[Hert]

How large is the backup file?

Btw. On postgresql you can always backup with the pg tools; eg pg_dumo or from witching pgAdmin. Those will be a multitude faster to use as backup.

[rdv4rjm]

Finally got to it yesterday.

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.

[Hert]

At minimum backup the photosupreme database (using pg_dump or pgAdmin).

The thumbs can always be rebuilt if needed. Backing up the thumbs database as well could be convenient and save time to get up and running when a restore is needed.