Re: Can't restart Postgres

On 02/15/2017 09:03 AM, Shawn Thomas wrote:
> /usr/lib/postgresql/9.4/bin/pg_ctl: No such file or directory
>
> postgres(at)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.

Ugh o.k.. I run Ubuntu so I don't have that problem.

The thread is a little confusing about what has been tried and what
hasn't but:

1. Disable ssl, try and start again
2. Try as postgres:

pg_ctlcluster 9.4 stop; pg_ctlcluster 9.4 start

3. Tom has a great suggestion if you are comfortable with those actions.

4. Is that directory listing the total of what is in 9.4/bin? If so... I
don't see a postgres binary?

JD

--
Command Prompt, Inc. http://the.postgres.company/
+1-503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Everyone appreciates your honesty, until you are honest with them.
Unless otherwise stated, opinions are my own.