From: vrms <vrms@netcologne.de>
To: pgsql-admin@lists.postgresql.org
Subject: Re: using pg_ctl over ssh hangs
Date: Fri, 20 Oct 2023 15:55:23 +0200
Message-ID: <9cec4fa8-3f98-4fa5-b12e-85441a8e3326@netcologne.de> (raw)
In-Reply-To: <b4603ebf-afef-4b6a-af75-de7fd26c9924@quadratum-braccas.com>
References: <b4603ebf-afef-4b6a-af75-de7fd26c9924@quadratum-braccas.com>
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
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: vrms@netcologne.de, pgsql-admin@lists.postgresql.org
Subject: Re: using pg_ctl over ssh hangs
In-Reply-To: <9cec4fa8-3f98-4fa5-b12e-85441a8e3326@netcologne.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox