Connection error on moduledb.crc.pitt.edu deployment

[Comeani]

Using the notes for connecting that I wrote up when we first took a look at the module database on moduledb.crc.pitt.edu, I am running into a psql connection issue where it's missing a file corresponding to the connection:

[nlc60@moduledb ~] : sudo su lmod_ingest
[sudo] password for nlc60: 

[lmod_ingest@moduledb ~] : cd /home/lmod_ingest

[lmod_ingest@moduledb ~] : psql -d lmod_tracking
psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: No such file or directory
    Is the server running locally and accepting connections on that socket?

I'm hoping to update the list of modules I have for the RHEL9 installs sometime soon, so maybe we can take a closer look at this later this week when we meet about the software installations.

[Comeani]

The postgresql service has been down for some time:

[root@moduledb ~]# systemctl status postgresql
● postgresql.service - PostgreSQL database server
   Loaded: loaded (/usr/lib/systemd/system/postgresql.service; enabled; vendor preset: disabled)
   Active: failed (Result: exit-code) since Fri 2023-12-08 17:46:41 EST; 2 months 0 days ago
  Process: 26545 ExecStart=/usr/bin/postmaster -D ${PGDATA} (code=exited, status=1/FAILURE)
 Main PID: 26545 (code=exited, status=1/FAILURE)

Having the NOC folks take a look to see if they can figure out why.