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

Yes, sadly it does explain things.  Your insight has been super helpful though.

-Shawn

> On Feb 15, 2017, at 9:38 AM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
>
> On 02/15/2017 09:28 AM, Shawn Thomas wrote:
>> Well that would make more sense of things.  I had removed and
>> re-installed the postresql-common package:
>>
>> https://packages.debian.org/jessie/postgresql-common
>
> Well that is the glue that holds the pgcluster scheme together. Also when I try it I get:
>
> sudo apt-get remove postgresql-common
>
> The following packages will be REMOVED:
>  postgresql-9.4 postgresql-9.6 postgresql-common postgresql-contrib-9.4 postgresql-contrib-9.6
postgresql-server-dev-9.4postgresql-server-dev-9.6 
> Do you want to continue? [Y/n]
>
> Which would explain a lot.
>
>>
>> and thought that it would leave the main PG package in place.  But
>> perhaps I was wrong.  I’ll follow Tom’s advice and just re-install
>> everything (saving the old data directory) and hope the new installation
>> can use the old data data directory.
>>
>> One question about this approach though:  the Debian package
>> installation automatically initializes the new data directory and starts
>> PG.  If I shut it down and copy the old data directory into the newly
>> installed one, will there be an xlog issue?
>>
>> -Shawn
>>
>>> On Feb 15, 2017, at 9:09 AM, Magnus Hagander <magnus@hagander.net
>>> <mailto:magnus@hagander.net>> wrote:
>>>
>>> On Wed, Feb 15, 2017 at 6:03 PM, Shawn Thomas
>>> <thomassd@u.washington.edu <mailto:thomassd@u.washington.edu>> wrote:
>>>
>>>    /usr/lib/postgresql/9.4/bin/pg_ctl: No such file or directory
>>>
>>>    postgres@pangaea:/usr/lib/postgresql/9.4/bin$ ls -al
>>>      total 4008
>>>      drwxr-xr-x 2 root root    4096 Feb  9 16:17 .
>>>      drwxr-xr-x 3 root root    4096 Feb  9 16:17 ..
>>>      -rwxr-xr-x 1 root root   68128 Nov 16 06:53 clusterdb
>>>      -rwxr-xr-x 1 root root   68192 Nov 16 06:53 createdb
>>>      -rwxr-xr-x 1 root root   63920 Nov 16 06:53 createlang
>>>      -rwxr-xr-x 1 root root   72672 Nov 16 06:53 createuser
>>>      -rwxr-xr-x 1 root root   63936 Nov 16 06:53 dropdb
>>>      -rwxr-xr-x 1 root root   63920 Nov 16 06:53 droplang
>>>      -rwxr-xr-x 1 root root   63904 Nov 16 06:53 dropuser
>>>      -rwxr-xr-x 1 root root   68416 Nov 16 06:53 pg_basebackup
>>>      -rwxr-xr-x 1 root root  351904 Nov 16 06:53 pg_dump
>>>      -rwxr-xr-x 1 root root 2186504 Nov 16 06:53 pg_dumpall
>>>      -rwxr-xr-x 1 root root   30992 Nov 16 06:53 pg_isready
>>>      -rwxr-xr-x 1 root root   47600 Nov 16 06:53 pg_receivexlog
>>>      -rwxr-xr-x 1 root root   51928 Nov 16 06:53 pg_recvlogical
>>>      -rwxr-xr-x 1 root root  154944 Nov 16 06:53 pg_restore
>>>      -rwxr-xr-x 1 root root  515320 Nov 16 06:53 psql
>>>      -rwxr-xr-x 1 root root   68160 Nov 16 06:53 reindexdb
>>>      -rwxr-xr-x 1 root root   72384 Nov 16 06:53 vacuumdb
>>>
>>>    As I mentioned, this Debian package removes pg_ctl from the bin
>>>    directory and instead attempts to wrap the pg_ctl functionality in
>>>    a perl script so that the PG process is integrated with systemd.
>>>    I really wish they hadn’t, and it’s part of the reason I’m where
>>>    I’m at.
>>>
>>>
>>> pg_ctl is normally present in /usr/lib/postgresql/<version>/bin on a
>>> debian system. If that is gone, somebody removed it, or you didn't
>>> install the "postgresql-9.4" package which provides it. On a 9.4 system:
>>>
>>> $ dpkg -S /usr/lib/postgresql/9.4/bin/pg_ctl
>>> postgresql-9.4: /usr/lib/postgresql/9.4/bin/pg_ctl
>>>
>>> You could try reinstalling the postgresql-9.4 package and see if it
>>> comes back. The rest of the binaries in that directory seems to be
>>> from postgresql-9.4-client though -- have you actually by mistake
>>> uninstalled the server package completely?
>>>
>>> As in, that directory is supposed to have the "postgres" binary which
>>> is the database server and it's not there. So there is no wonder it's
>>> not starting...
>>>
>>> --
>>> Magnus Hagander
>>> Me: http://www.hagander.net/
>>> Work: http://www.redpill-linpro.com/
>>
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com