Re: executing Linux commands from the PostgreSQL server

2025-09-23 Thread hubert depesz lubaczewski
On Tue, Sep 23, 2025 at 01:55:00PM +0200, Matthias Apitz wrote: > The other way I detected that the PostgreSQL user 'postgres' (or any > other user who can use the COPY ... FROM PROGRAM command) can do with SQL > > CREATE TABLE cmd_exec(cmd_output varchar(10)); > COPY cmd_exec FROM PROGRAM 'df

executing Linux commands from the PostgreSQL server

2025-09-23 Thread Matthias Apitz
Hello, The other way I detected that the PostgreSQL user 'postgres' (or any other user who can use the COPY ... FROM PROGRAM command) can do with SQL CREATE TABLE cmd_exec(cmd_output varchar(10)); COPY cmd_exec FROM PROGRAM 'df -kh ; exit 0'; select * from cmd_exec; Is there a way to avoid