Re: [GENERAL] Can't restart Postgres - Mailing list pgsql-general

From Magnus Hagander
Subject Re: [GENERAL] Can't restart Postgres
Date
Msg-id CABUevEwi9ycWRoiZj8pqGcFbkd9-HiK_JbrWFq=oM8w0iFemxg@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] Can't restart Postgres  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: [GENERAL] Can't restart Postgres  (Shawn Thomas <thomassd@u.washington.edu>)
List pgsql-general
On Tue, Feb 14, 2017 at 8:47 PM, Joshua D. Drake <jd@commandprompt.com> wrote:
On 02/14/2017 11:43 AM, Shawn Thomas wrote:
pangaea:/var/log# systemctl status postgresql
● postgresql.service - PostgreSQL RDBMS
   Loaded: loaded (/lib/systemd/system/postgresql.service; enabled)
   Active: active (exited) since Tue 2017-02-14 10:48:18 PST; 50min ago
  Process: 28668 ExecStart=/bin/true (code=exited, status=0/SUCCESS)
 Main PID: 28668 (code=exited, status=0/SUCCESS)
   CGroup: /system.slice/postgresql.service

What about if use pg_ctl as the postgres user? That will give you a better idea.

You don't want ot be doing that on a systemd system, but try a combination of pg_lsclusters and pg_ctlcluster. Might be you need to shut it down once that way before it realizes it's down,and then start it back up. 


--

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: [GENERAL] Can't restart Postgres
Next
From: Moreno Andreo
Date:
Subject: Re: [GENERAL] Can't restart Postgres