Forum archive
Postgresql failed to start after chnaging acidently network device
Hello,
Postgresql service stopped working after changing network device. the appliance is running as VM in proxmox.
Please help.
Thank you
Forum archive
Hello,
Postgresql service stopped working after changing network device. the appliance is running as VM in proxmox.
Please help.
Thank you
That should tell you if it's running or not and may also give you some clues on what might be going wrong.
If it's not running, you can start it. If it is running, then you can try to restart it (although I'm not sure that will be enough).
To start (if not running):
To restart (if already running - you can probably guess this one already):
If none of that really helps, then probably the next thing to check is the log file. I don't recall what it is exactly, but it should be in /var/log; probably /var/log/postgres/ or similar. If you have a look in /var/log you should find something that looks relevant. If it doesn't make any sense to you, then feel free to post the bottom ~10-15 lines of it.
Another tool which may come in handy when trying to resolve issues like this is netstat. You can use that to see if it's listening as you expect. So something like this should help: