Database won't start after drive failure

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

Database won't start after drive failure

Post by cardio1 » 17 Jan 21 18:18

I ran PS on an external drive and backed it up to the cloud for the last several years. The drive itself went to heaven :) so I restored it from backup and that looked good.
When I try to open PS I get what is on the screen shot.
The drive is labeled the same and the structure is the same.
5432 is shown as connection
What am I doing wrong?
database issue.jpg

weidmic
moderator
Posts: 858
Joined: 04 Dec 06 22:21

Re: Database won't start after drive failure

Post by weidmic » 17 Jan 21 22:49

Hi Cardio,
Can you try to attach the file again?

Best Regards,
Michael
PSUServer 6.x, PostgreSQL 12.x
My homepage http://www.michaelweidner.com

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

Re: Database won't start after drive failure

Post by cardio1 » 18 Jan 21 16:33

database issue.jpg
database issue.jpg (292.59 KiB) Viewed 675 times

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

Re: Database won't start after drive failure

Post by Hert » 18 Jan 21 16:50

That looks like either:
1. PostgreSQL is not started (check in Windows Services)
2. PostgreSQL is not correctly configured according to the installation instructions, more particularly the pg_hba.conf
https://manualsu.idimager.com/version5/ ... upreme.pdf
3. A firewall is blocking port 5432 from PostgreSQL
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 » 19 Jan 21 15:54

Hert,
1. PostgreSQL in windows services is listed as stopped and won't stay running...says it needs an app to stay running
2. .conf file matches
3. firewall is configured to pass 5432
Would it hurt to remove Postgresql and reinstall? Would that disturb thumb labels and database?
Ralph

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

Re: Database won't start after drive failure

Post by Hert » 19 Jan 21 17:45

PostgreSQL is the database. So if you uninstall it you will also delete the catalog. Make sure that you have a backup available before uninstalling.
You don’t get any message on why PostgreSQL won’t start? Did you also check in Windows events log?
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 » 19 Jan 21 20:23

So I probably don't want to do that eh?
Attached are the configurations of the config file and the hierarchy of the drive.
Additional message now is "database not found"
Attachments
Screen Shot 01-19-21 at 01.14 PM.JPG
Screen Shot 01-19-21 at 01.14 PM.JPG (973.18 KiB) Viewed 625 times
Screen Shot 01-19-21 at 01.13 PM.JPG
Screen Shot 01-19-21 at 01.13 PM.JPG (1.19 MiB) Viewed 625 times
Screen Shot 01-19-21 at 01.14 PM 001.JPG
Screen Shot 01-19-21 at 01.14 PM 001.JPG (994.95 KiB) Viewed 625 times

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

Re: Database won't start after drive failure

Post by cardio1 » 19 Jan 21 20:27

This is from windows event from this morning...nothing this afternoon.
Attachments
Screen Shot 01-19-21 at 01.26 PM.JPG
Screen Shot 01-19-21 at 01.26 PM.JPG (478.98 KiB) Viewed 625 times

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

Re: Database won't start after drive failure

Post by Hert » 20 Jan 21 17:01

Does the Windows user that runs the PostgreSQL Service also have access rights to the PostgreSQL data folder that you have configured?
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 Jan 21 22:18

Hert,
Single user computer...just me. So, rights I guess would be ok. I don't know how to check though.
Ralph

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

Re: Database won't start after drive failure

Post by cardio1 » 20 Jan 21 22:22

Is this what you are concerned about?
Attachments
Screen Shot 01-20-21 at 03.20 PM.JPG
Screen Shot 01-20-21 at 03.20 PM.JPG (527.09 KiB) Viewed 555 times

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

Re: Database won't start after drive failure

Post by Hert » 21 Jan 21 0:57

Check in the Windows services what user is configured to run the Postgresql service (open the service it’s properties). Optionally change it to your user account
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 » 22 Jan 21 2:26

So this is what is says now
Change it to master and admin2004?
Attachments
Screen Shot 01-21-21 at 07.23 PM 001.JPG
Screen Shot 01-21-21 at 07.23 PM 001.JPG (590.4 KiB) Viewed 468 times

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

Re: Database won't start after drive failure

Post by Hert » 22 Jan 21 6:35

cardio1 wrote:
22 Jan 21 2:26
Change it to master and admin2004?
No, those are PSU login details. But you’re looking at a Windows service, and what Windows account runs that service. That is unrelated to PSU.

Change it to your Windows login username and password. The user you enter there must have access (Windows access) to the folder where you keep your database files.
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 » 22 Jan 21 16:00

I'm only user Ralph (administrator) so searched for Ralph user and not found therefore searched for administrator and found that. Added as user and updated password. Services responded "administrator granted privileges"
Restarted computer.
No joy in Hooterville
Same screen :(
(I started PS as administrator too)
Attachments
Screen Shot 01-22-21 at 09.02 AM.JPG
Screen Shot 01-22-21 at 09.02 AM.JPG (539.75 KiB) Viewed 414 times
Last edited by cardio1 on 22 Jan 21 18:08, edited 1 time in total.

Post Reply