Horton

Re: Add pg_file_sync() to adminpack

Atsushi Torikoshi <atorik@gmail.com>

View thread View on postgr.es
From: Atsushi Torikoshi <atorik@gmail.com>
To: Julien Rouhaud <rjuju123@gmail.com>
Cc: Fujii Masao <masao.fujii@gmail.com>, Michael Paquier <michael@paquier.xyz>, Arthur Zakirov <zaartur@gmail.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2020-01-15T12:59:59Z
Lists: pgsql-hackers 
On Wed, Jan 15, 2020 at 1:49 Julien Rouhaud <rjuju123@gmail.com>:

> Actually, pg_write_server_files has enough privileges to execute those
> functions anywhere on the FS as far as C code is concerned, provided
> that the user running postgres daemon is allowed to (see
> convert_and_check_filename), but won't be allowed to do so by default
> as it won't have EXECUTE privilege on the functions.
>

I see, thanks for your explanation.

--
Regards,
Atsushi Torikoshi

Commits

  1. Add pg_file_sync() to adminpack extension.