pg.ddx.io  pgsql-pkg-debian@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Christoph Berg <myon@debian.org>
To: Jose Herrera <josehr1108@gmail.com>
Cc: pgsql-pkg-debian@postgresql.org
Subject: Re: Postgres service is not running
Date: Thu, 14 Dec 2017 13:42:15 +0100
Message-ID: <20171214124215.GD5775@msg.df7cb.de> (raw)
In-Reply-To: <CACwLt51TYvOfycBpEwRi71GKTNx=k2RKo-Ts0f2XsgwGUE9h0w@mail.gmail.com>
References: <CACwLt51TYvOfycBpEwRi71GKTNx=k2RKo-Ts0f2XsgwGUE9h0w@mail.gmail.com>

Re: Jose Herrera 2017-12-13 <CACwLt51TYvOfycBpEwRi71GKTNx=k2RKo-Ts0f2XsgwGUE9h0w@mail.gmail.com>
> The postgres service status its the following:
>    postgresql.service - PostgreSQL RDBMS
>    Loaded: loaded (/lib/systemd/system/postgresql.service; enabled; vendor
> prese
>    Active: active (exited) since vie 2017-12-08 13:09:05 CST; 1h 43min ago
>    Process: 813 ExecStart=/bin/true (code=exited, status=0/SUCCESS)
>    Main PID: 813 (code=exited, status=0/SUCCESS)
>    CGroup: /system.slice/postgresql.service
> 
> As you can see the service its active(exited), not running, and the PID its
> not present on the list of processes when i run *ps -A*.
> I have tried with apt repository installations of Postgresql versions 9.5,
> 9.6, 10 and with EnterpriseDB installer and still got this error.
> I have read that it has to be a postgres fault with the systemd integration
> of the OS, but i have tried many solutions and nothing seems to work.

Hi,

postgresql.service is only a stub that bundles the actual instances
which are called like postgresql@10-main.service. If you look that
their status, you'll see the actual postgres processes:

● postgresql@10-main.service - PostgreSQL Cluster 10-main
   Loaded: loaded (/lib/systemd/system/postgresql@.service; indirect; vendor preset: enabled)
   Active: active (running) since Thu 2017-12-14 13:41:57 CET; 218ms ago
  Process: 18597 ExecStop=/usr/bin/pg_ctlcluster --skip-systemctl-redirect -m fast 10-main stop (code=exited, status=0/SUCCESS)
  Process: 4919 ExecStart=/usr/bin/pg_ctlcluster --skip-systemctl-redirect 10-main start (code=exited, status=0/SUCCESS)
 Main PID: 4924 (postgres)
    Tasks: 8 (limit: 4915)
   CGroup: /system.slice/system-postgresql.slice/postgresql@10-main.service
           ├─4924 /usr/lib/postgresql/10/bin/postgres -D /var/lib/postgresql/10/main -c config_file=/etc/postgresql/10/main/postgresql.conf
           ├─4926 postgres: 10/main: checkpointer process
           ├─4927 postgres: 10/main: writer process
           ├─4928 postgres: 10/main: wal writer process
           ├─4929 postgres: 10/main: autovacuum launcher process
           ├─4930 postgres: 10/main: archiver process
           ├─4931 postgres: 10/main: stats collector process
           └─4932 postgres: 10/main: bgworker: logical replication launcher

Christoph




view thread (3+ messages)  latest in thread

Message-ID: <20171214124215.GD5775@msg.df7cb.de>
Permalink:  ../20171214124215.GD5775@msg.df7cb.de/
Also on:    postgresql.org/message-id/20171214124215.GD5775@msg.df7cb.de

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-pkg-debian@postgresql.org
  Cc: myon@debian.org, josehr1108@gmail.com
  Subject: Re: Postgres service is not running
  In-Reply-To: <20171214124215.GD5775@msg.df7cb.de>
  References: <CACwLt51TYvOfycBpEwRi71GKTNx=k2RKo-Ts0f2XsgwGUE9h0w@mail.gmail.com> <20171214124215.GD5775@msg.df7cb.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox