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
Backup fails PSU quits
Re: Backup fails PSU quits
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
Feature requests, change suggestions, or bugs can be logged in the ticketing system
Re: Backup fails PSU quits
I am using Server Edition
Postgres on Mac
Postgres on Mac
Re: Backup fails PSU quits
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.
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
Feature requests, change suggestions, or bugs can be logged in the ticketing system
Re: Backup fails PSU quits
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.
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.
Re: Backup fails PSU quits
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.
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
Feature requests, change suggestions, or bugs can be logged in the ticketing system