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

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.4
postgresql-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