Cannot run backup tools

[LucLL]

Hi All,

Im currently getting the error that I can't run the backup tool.
I already compared the catalog and thumbs db but no improvement.
Would anyone have a tip how to get this working?

PS: I lost the postgres pwd, so I hoped to backup and restore the DBs after a reinstall of postgresql. (yes, dumb me)
Unless you have a tip to rester postgressql super user pwd?

I was hoping not having to rebuild the DBs as I have over 120K pictures and video in there.

Thats for any tip,

Regards,
Luc

backup error print screen

Screen Shot 2016-06-01 at 06.23.27.png (119.38 KiB) Viewed 5538 times

[fbungarz]

Are you sure you have enough space where the backup is being saved? If your database is large, then the backup will be large too...

[weidmic]

You can either you try the latest beta or
copy the pg_dump.exe from your postgreSQL installation to the photo supreme folder and overwrite the exiting pg_dump

another way would be to make a db copy is via pgadmin (however, I dont know how to restore it sucessfully)
But this way you have at least a backup

Hope this helps
Michael

[LucLL]

Are you sure you have enough space where the backup is being saved? If your database is large, then the backup will be large too...

Yep, no shortage on space. The free space is bigger then the total site of server storage so that can't (should,t) be the problem.
Thx for the tip anyway!

[luerman]

Environment: Windows 10 Pro 64-bit
PhotoSupreme Server v2.2.5.1045.pg
PostgreSQL v9.5

I too am getting this error when attempting to backup the catalog from within PhotoSupreme v2.2.5.1045.pg (64-bits). BUT strangely, the thumbs database backup works OK.

I copied the PostgreSQL v9.5 pg_dump.exe into the PS folder (replacing the PostgreSQL v9.3 pg_dump.exe that was installed with PS).

I can successfully backup the photosupreme database with this command using the "postgres" user:
pg_dump.exe --host 10.0.0.4 --port 5432 --dbname photosupreme --file "P:\Backup\photosupreme.pg.backup" --clean --create --blobs --format tar --username postgres
followed with the postgres password. (And the thumbs database can also be backed up this way.)

I tried using "--username idimager_main", but it does not work. I tried it both with my new password, and the original password (master2004). It fails with:
pg_dump: [archiver (db)] connection to database "photosupreme" failed: FATAL: password authentication failed for user "idimager_main"


The questions are:
1. Will I be able to restore from the backup produced using the postgres userid? I guess I'll have to test it.
2. Is PostgreSQL v9.5 the problem? Do I need to use PostgreSQL v9.3? I guess I'll have to test it.
3. Anybody have any suggestion on why the photosupreme database does NOT backup, but the photosupreme_thumbs database does backup OK?

If anyone out there knows the answers, it will save me some time Thanks.

NOTES:
1. Plenty of space. Not an issue.

[weidmic]

A to 2: yes, it is related to 9.5 (the beta does backup with 9.5 installed) - make sure when you install the beta, that you choose the correct PostgreSql version!