NetWorker: When the postgres daemon is not running, the NMC login prompts with error "Unable to connect to database"
Summary: NetWorker: When the postgres daemon is not running, the NMC login prompts with error "Unable to connect to database"
Symptoms
Accessing the NetWorker Management Console (NMC) returns: "Unable to connect to database"
The postgres daemon is not listed for the NMC GST service:
Linux: ps -ef | grep "gst\|lgtogst"
Windows (PowerShell): Get-WmiObject Win32_Process | Where-Object {$_.Name -match "gstd.exe|postgres.exe"} | Select-Object Name, ProcessID, CommandLine
The render of the gstd.raw file notes
gstd NSR warning: failed to get db connection to fetch server configuration
NetWorker: How to use nsr_render_log to render .raw log files
Linux: /opt/lgtonmc/logs/gstd.raw
Windows: <INSTALL_DRIVE>:\Program Files\EMC NetWorker\Management\GST\logs.gstd.raw
Cause
Resolution
- Stop the NMC daemons with:
Linux: /etc/init.d/gst stop or systemctl stop gst
Windows: net stop gstd
- Ensure the daemons stop with:
Linux: ps -ef | grep "gst\|lgtogst"
Windows (PowerShell): Get-WmiObject Win32_Process | Where-Object {$_.Name -match "gstd.exe|postgres.exe"} | Select-Object Name, ProcessID, CommandLine
- Terminate any NMC processes which did not shut down:
Linux: kill -9 PID
Windows: taskkill /F /PID PID
- Start the NMC daemons with:
Linux: /etc/init.d/gst start or systemctl start gst
Windows: net start gstd
- Ensure all daemons start with:
Linux: ps -ef | grep "gst\|lgtogst"
Windows (PowerShell): Get-WmiObject Win32_Process | Where-Object {$_.Name -match "gstd.exe|postgres.exe"} | Select-Object Name, ProcessID, CommandLine
Monitor the NMC gstd.raw and postgres logs for any errors:
NetWorker: How to use nsr_render_log to render .raw log files
Linux:
-
- /opt/lgtonmc/logs/gstd.raw
- /nsr/nmc/nmcdb/pgdata/pg_log/postgresql-DAY.log
Windows:
-
- <INSTALL_DRIVE>:\Program Files\EMC NetWorker\Management\GST\logs.gstd.raw
- <INSTALL_DRIVE>:\Program Files\EMC NetWorker\Management\nmcdb\pgdata\pg_log\postgresql-DAY.log