j***@yahoo.com
2018-01-17 21:05:11 UTC
I'm kind of new to PostgreSQL and I'm having problems finding how to restart Postgresql. I've been using Postgresql on the system for some weeks at least but all of sudden I couldn't connect any longer. I'm running Postgresql 10.1 on macOS High Sierra using pgAdmin3.
From my search I noticed postgresql is no longer running or listening on port 5432. I checked the logs and I noticed the last items on the logs show:
LOG:Â received smart shutdown requestLOG:Â worker process: logical replication launcher (PID 519) exited with exit code 1LOG:Â shutting downLOG:Â checkpoint starting: shutdown immediateLOG:Â checkpoint complete: wrote 0 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.003 s, sync=0.000 s, total=1.316 s; sync files=0, longest=0.000 s, average=0.000 s; distance=0 kB, estimate=152 kB
I can't recall stopping postgresql. I've been looking for how to restart Postgresql but the options I've seen online don't seem to solve the issue.
Any help will be fine because I don't want to have to reinstall postgresql and lose data from the earlier installation.
Thanks.
Mac O.
From my search I noticed postgresql is no longer running or listening on port 5432. I checked the logs and I noticed the last items on the logs show:
LOG:Â received smart shutdown requestLOG:Â worker process: logical replication launcher (PID 519) exited with exit code 1LOG:Â shutting downLOG:Â checkpoint starting: shutdown immediateLOG:Â checkpoint complete: wrote 0 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.003 s, sync=0.000 s, total=1.316 s; sync files=0, longest=0.000 s, average=0.000 s; distance=0 kB, estimate=152 kB
I can't recall stopping postgresql. I've been looking for how to restart Postgresql but the options I've seen online don't seem to solve the issue.
Any help will be fine because I don't want to have to reinstall postgresql and lose data from the earlier installation.
Thanks.
Mac O.