Connection error on moduledb.crc.pitt.edu deployment
Opened this issue · 1 comments
Comeani commented
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 commented
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.