Re: [GENERAL] psql remote shell command

2016-06-03 Thread Merlin Moncure
On Thu, Jun 2, 2016 at 6:54 PM, Michael Paquier wrote: > On Fri, Jun 3, 2016 at 8:48 AM, David G. Johnston > wrote: >> On Thu, Jun 2, 2016 at 7:39 PM, Michael Paquier >> wrote: >> I was focused on admin task due to the pg_ctl (not sure you'd want to run >> that via psql...) but if you have shell

Re: [GENERAL] psql remote shell command

2016-06-02 Thread Dennis
Wow, thanks for all the feedback. The question about whether a superuser could do something like this came up at the office today in the context of security issues and handing out superuser to the application users (not necessarily to the accounts/roles that would be used from the applications

Re: [GENERAL] psql remote shell command

2016-06-02 Thread John R Pierce
On 6/2/2016 4:42 PM, David G. Johnston wrote: ​ssh user@hostname ? ^ ++ -- john r pierce, recycling bits in santa cruz

Re: [GENERAL] psql remote shell command

2016-06-02 Thread David G. Johnston
On Thu, Jun 2, 2016 at 7:54 PM, Stephen Frost wrote: > * Dennis (denn...@visi.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 run

Re: [GENERAL] psql remote shell command

2016-06-02 Thread Stephen Frost
* David G. Johnston (david.g.johns...@gmail.com) wrote: > On Thu, Jun 2, 2016 at 7:30 PM, Dennis 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 ho

Re: [GENERAL] psql remote shell command

2016-06-02 Thread Stephen Frost
* Dennis (denn...@visi.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 l

Re: [GENERAL] psql remote shell command

2016-06-02 Thread Michael Paquier
On Fri, Jun 3, 2016 at 8:48 AM, David G. Johnston wrote: > On Thu, Jun 2, 2016 at 7:39 PM, Michael Paquier > wrote: > I was focused on admin task due to the pg_ctl (not sure you'd want to run > that via psql...) but if you have shell script applications you want to run > you could consider: > > h

Re: [GENERAL] psql remote shell command

2016-06-02 Thread David G. Johnston
On Thu, Jun 2, 2016 at 7:39 PM, Michael Paquier wrote: > On Fri, Jun 3, 2016 at 8:30 AM, Dennis 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 h

Re: [GENERAL] psql remote shell command

2016-06-02 Thread David G. Johnston
On Thu, Jun 2, 2016 at 7:30 PM, Dennis 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

Re: [GENERAL] psql remote shell command

2016-06-02 Thread Michael Paquier
On Fri, Jun 3, 2016 at 8:30 AM, Dennis 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 p

[GENERAL] psql remote shell command

2016-06-02 Thread Dennis
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 post