Search Postgresql Archives

Re: Can't restart Postgres

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 02/14/2017 05:00 PM, Adrian Klaver wrote:
On 02/14/2017 12:00 PM, Shawn Thomas wrote:
Yes that would be the standard approach.  But the Debian package removes
pg_ctl from it normal place and wraps it with a perl script in a way
that makes it difficult to work with (it doesn’t accept the same
arguments):

https://wiki.debian.org/PostgreSql#pg_ctl_replacement

@Mangnus, can you give me an example of how I might use pg_lsclusters
and pg_ctlcluster?  I’ve tried:


I do not see a sudo below or is it apparent whether you are doing this
as the postgres user.

pg_ctlcluster 9.4 main start
Error: could not exec   start -D /var/lib/postgresql/9.4/main -l
/var/log/postgresql/postgresql-9.4-main.log -s -o  -c
config_file="/etc/postgresql/9.4/main/postgresql.conf”

Not sure how close Debian 8 is to Ubuntu 16.04(something I use), but
from your first post they look like they share the same startup scripts.
So something like:

sudo systemctl restart postgresql@9.4-main.service
                 ^^^^^^^
      Should be  start



-Shawn

On Feb 14, 2017, at 11:52 AM, Magnus Hagander <magnus@xxxxxxxxxxxx
<mailto:magnus@xxxxxxxxxxxx>> wrote:

On Tue, Feb 14, 2017 at 8:47 PM, Joshua D. Drake <jd@xxxxxxxxxxxxxxxxx
<mailto:jd@xxxxxxxxxxxxxxxxx>> 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.


--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/





--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux