Database won't start after drive failure

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

Re: Database won't start after drive failure

Post by Hert » 09 Feb 21 10:54

You can upload the zipped file to your cloud drive (Google Drive/DropBox/OneDrive/iCloud/WeTransfer...) and send a download link to support@idimager.com
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

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

Re: Database won't start after drive failure

Post by Hert » 13 Feb 21 10:55

Thank you for sending me the backup file. The file is 300KB, and is from an empty database

For time sake, I suggest you start all over and import your files from the file system with ICS switched ON.

Follow these steps:
1. Restart the computer
2. Start PSU while holding down Ctrl+Win+Alt
3. In the database creation dialog, create a new catalog
4. Once completed, start PSU and login to your new catalog
5. In preferences, switch ON ICS reading in the Sync-Read settings
6. Import your files from the file system using "Import from Folder" from the hamburger menu
7. After the import is completed, switch OFF the ICS reading again
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

cardio1
Posts: 63
Joined: 25 Apr 07 4:21

Re: Database won't start after drive failure

Post by cardio1 » 14 Feb 21 16:25

Hert,
You can see the I drive my files are stored on on previous posts above. What files should I identify to "import" from? The previous thumbs or all the stored images?
Ralph

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

Re: Database won't start after drive failure

Post by Hert » 14 Feb 21 17:09

In Step 6, select the root folder that contains your original photos. If you have multiple root folders then repeat step 6 for every root folder.
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

cardio1
Posts: 63
Joined: 25 Apr 07 4:21

Re: Database won't start after drive failure

Post by cardio1 » 16 Feb 21 18:01

Well HALLELUJAH! We have lift off and landing too!
The database is there along with my labels!
Thank you so much for your help and patience Hert!
I am not a computer whiz as you can tell, much less comfortable with Postgres. But you made it happen.
Ralph

cardio1
Posts: 63
Joined: 25 Apr 07 4:21

Re: Database won't start after drive failure

Post by cardio1 » 16 Feb 21 20:30

Well now
Interesting behavior trying to backup
See screen shot from ps at the bottom left where it is trying to backup images? I've not seen that before.
Also second screen shot with multiple database errors. Ignore, play on?
Attachments
Screen Shot 02-16-21 at 01.51 PM.JPG
Screen Shot 02-16-21 at 01.51 PM.JPG (83.71 KiB) Viewed 129 times
Screen Shot 02-16-21 at 01.47 PM.JPG
Screen Shot 02-16-21 at 01.47 PM.JPG (153.1 KiB) Viewed 129 times

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

Re: Database won't start after drive failure

Post by Hert » 17 Feb 21 10:37

It's not going easy hahaha.

Could it be that a restore process is still running in pgAdmin? If you're sure there isn't (for expample after a reboot of the computer) then you'll need to manually get PostgreSQL out of recovery mode (I have had this only once in the many years I have been using PostgreSQL)

This could help:
https://stackoverflow.com/questions/560 ... -only-mode
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

cardio1
Posts: 63
Joined: 25 Apr 07 4:21

Re: Database won't start after drive failure

Post by cardio1 » 20 Feb 21 0:07

A challenge way beyond my skillset but...
I've now backed up without errors and on pgadmin I have 3 databases now: postgres has 7575kb, thumbs is 10gb, photosupreme is 840mb. Is that about what you would expect or should I send you the files to be sure Hert?

cardio1
Posts: 63
Joined: 25 Apr 07 4:21

Re: Database won't start after drive failure

Post by cardio1 » 24 Feb 21 23:55

To close the book on this thread:
Finally all things are back to normal. Upgraded to v6 and that seemed to help. Hert did some magic with my database which helped too.
I learned more about PostgreSQL than I ever wanted to know.
Thanks for watching :)

Post Reply