Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1ePSqC-0003rA-Cb for pgsql-pkg-debian@arkaria.postgresql.org; Thu, 14 Dec 2017 12:42:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1ePSqC-0000YD-00 for pgsql-pkg-debian@arkaria.postgresql.org; Thu, 14 Dec 2017 12:42:19 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1ePSqB-0000Y3-Ri for pgsql-pkg-debian@lists.postgresql.org; Thu, 14 Dec 2017 12:42:19 +0000 Received: from feynman.df7cb.de ([195.49.152.168]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1ePSq9-0003e9-F8 for pgsql-pkg-debian@postgresql.org; Thu, 14 Dec 2017 12:42:19 +0000 Received: from msg.df7cb.de (unknown [IPv6:2003:5b:203b:100:7627:eaff:fe52:8e03]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by feynman.df7cb.de (Postfix) with ESMTPSA id 3yyCr85cDWz3F0C; Thu, 14 Dec 2017 13:42:16 +0100 (CET) Date: Thu, 14 Dec 2017 13:42:15 +0100 From: Christoph Berg To: Jose Herrera Cc: pgsql-pkg-debian@postgresql.org Subject: Re: Postgres service is not running Message-ID: <20171214124215.GD5775@msg.df7cb.de> Mail-Followup-To: Christoph Berg , Jose Herrera , pgsql-pkg-debian@postgresql.org References: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/1.9.1 (2017-09-22) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Re: Jose Herrera 2017-12-13 > 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