using pg_ctl over ssh hangs

From: Sbob <sbob(at)quadratum-braccas(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: using pg_ctl over ssh hangs
Date: 2023-10-20 01:24:37
Message-ID: b4603ebf-afef-4b6a-af75-de7fd26c9924@quadratum-braccas.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

All

I am wanting to run pg_ctl as a command over ssh, however when I pass
start it hangs until I do a Ctl-C

This works fine:

$ node3=172.16.171.132
$ ssh -T postgres(at)${node3} "/usr/pgsql-14/bin/pg_ctl -D
/var/lib/pgsql/14/data stop"
waiting for server to shut down.... done
server stopped
$

I am immediately returned to a command prompt

However , this does not return me to a command prompt until I do a Ctl-C:

$ node3=172.16.171.132

$ ssh -T postgres(at)${node3} "/usr/pgsql-14/bin/pg_ctl -D
/var/lib/pgsql/14/data start"
waiting for server to start....2023-10-19 19:23:42.947 MDT [2053] LOG:
 redirecting log output to logging collector process
2023-10-19 19:23:42.947 MDT [2053] HINT:  Future log output will appear
in directory "log".
done
server started

^C
$

Thanks in advance

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2023-10-20 01:31:49 Re: using pg_ctl over ssh hangs
Previous Message Alex Williams 2023-10-19 22:43:30 Re: postgresql14-contrib does not install with libpython 3.7