From: | "jlymarius(at)yahoo(dot)com" <jlymarius(at)yahoo(dot)com> |
---|---|
To: | "pgsql-novice(at)lists(dot)postgresql(dot)org" <pgsql-novice(at)lists(dot)postgresql(dot)org> |
Subject: | Restarting PostgreSQL 10.1 |
Date: | 2018-01-17 21:05:11 |
Message-ID: | 768298557.5386658.1516223111763@mail.yahoo.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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 | Date | Subject | |
---|---|---|---|
Next Message | Garry Chen | 2018-01-18 19:08:59 | how to remove set_config from all user |
Previous Message | RABIN NATHAN | 2018-01-17 08:10:21 | Re: why do i get 2 as answer for select length('aa '::char(6)); |