Backup fails PSU quits

Post Reply
rdv4rjm
Posts: 83
Joined: 08 May 18 22:29

Backup fails PSU quits

Post by rdv4rjm » 11 Dec 18 5:28

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
Posts: 21433
Joined: 13 Sep 03 7:24

Re: Backup fails PSU quits

Post by Hert » 11 Dec 18 11:03

Are you using Single or Server edition? If the latter, what database system?
This is a User-to-User forum which means that users post questions here for other users.
Feature requests, change suggestions, or bugs can be logged in the ticketing system

rdv4rjm
Posts: 83
Joined: 08 May 18 22:29

Re: Backup fails PSU quits

Post by rdv4rjm » 11 Dec 18 15:26

I am using Server Edition
Postgres on Mac

Hert
Posts: 21433
Joined: 13 Sep 03 7:24

Re: Backup fails PSU quits

Post by Hert » 12 Dec 18 14:31

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.
This is a User-to-User forum which means that users post questions here for other users.
Feature requests, change suggestions, or bugs can be logged in the ticketing system

rdv4rjm
Posts: 83
Joined: 08 May 18 22:29

Re: Backup fails PSU quits

Post by rdv4rjm » 16 Jan 19 7:41

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
Posts: 21433
Joined: 13 Sep 03 7:24

Re: Backup fails PSU quits

Post by Hert » 16 Jan 19 9:21

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.
This is a User-to-User forum which means that users post questions here for other users.
Feature requests, change suggestions, or bugs can be logged in the ticketing system

Post Reply