From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
---|---|
To: | Dennis <dennisr(at)visi(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: psql remote shell command |
Date: | 2016-06-02 23:39:25 |
Message-ID: | CAB7nPqTKK5fOBuoBKFLdo9YhnauL+eYXiSFaWaV_sO0zaUi1tw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, Jun 3, 2016 at 8:30 AM, Dennis <dennisr(at)visi(dot)com> wrote:
> Is it possible to execute command in on system the is hosting postgresql
> remotely using psql or other mechanism? I know I can use \! in psql but
> that executes the commands on the host where I am running psql from. Also,
> is it possible for a postgres login/user to stop or restart a running
> postgres instance from in side psql or similar client. e.g. psql -c “pg_ctl
> stop -D some_data_dir”
Not directly. You could implement an extension that wraps a function
available at SQL level taking some actions, however for the restart
the error handling is tricky if you just have control via psql. How
could you start a node that has been stopped during a restart but
could not boot up. Take the example of an incorrect parameter value
that has been added when the node was up via ALTER SYSTEM...
--
Michael
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2016-06-02 23:42:48 | Re: psql remote shell command |
Previous Message | Dennis | 2016-06-02 23:30:20 | psql remote shell command |