| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(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:42:48 |
| Message-ID: | CAKFQuwbSYqkXRZa+t4u9hJay1VR1H8LYUWQkBFqU1iqPn=CCgw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Jun 2, 2016 at 7:30 PM, 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”
>
ssh user(at)hostname ?
You should ask your system administrator for help. Odds are if you cannot
do "ssh user(at)hostname" then the person hosting the server doesn't want you
to be able to execute arbitrary commands on the host.
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2016-06-02 23:48:37 | Re: psql remote shell command |
| Previous Message | Michael Paquier | 2016-06-02 23:39:25 | Re: psql remote shell command |