Restarting PostgreSQL 10.1

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.

Browse pgsql-novice by date

  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));