even though this may not be 100% what you where asking for ...
the first thing that comes to mind would be trying to send the remote command into the background
$ ssh -T postgres@${node3} "/usr/pgsql-14/bin/pg_ctl -D /var/lib/pgsql/14/data start &"
this may come with the disadvantage that you do not receive the "server started" feedback.
the second was to try Ansible
- name: start postgres @ node 3
hosts: node3
tasks:
- name: start postgresql
ansible.builtin.cmd
cmd: "/usr/pgsql-14/bin/pg_ctl -D /var/lib/pgsql/14/data start"
become: true
become_user: postgres
this of course requires for you to have Ansible available (which may come handy anyway).
On 20.10.23 03:24, Sbob wrote:
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@${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@${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