Disallow execution of shell commands from psql

From: Wiwwo Staff <wiwwo(at)wiwwo(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Disallow execution of shell commands from psql
Date: 2023-01-10 18:01:24
Message-ID: CAFe70G6=XkdZKwdGOQA-Ccr9QYAS9_G+FULAO08yTy_7Z9=xDA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!
Happy new (gregorian calendar) year!

Somehow related to the proposal of having a `psql --idle` option, is there
a way to disallow the command `\!` (and anything of the likes in psql?

Sure, I can set the SHELL env var at run-time, but I still want to have
postgres user to be a normal user, with its shell etc, which means it can
change this SHELL setting somewhere.

Any tip?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Julien Rouhaud 2023-01-11 05:02:05 Re: Use case for enabling log_duration other than benchmarking
Previous Message Ron 2023-01-10 16:28:29 Re: Use case for enabling log_duration other than benchmarking