Re: File permissions set when uploaded using file manager

On Thu, 20 Oct 2022 at 10:16, Yogesh Mahajan <
yogesh(dot)mahajan(at)enterprisedb(dot)com> wrote:

> Hi Dave/Team,
>
> When files are uploaded using file manager, access permissions of the file
> are set to 644.
> However, the key file used while connecting to postgresql using SSL,
> should have access permission 600 or less.
> To fix this issue the user has to explicitly modify file permissions via
> command line.
>
> In server mode, if the user does not have command line access to the
> pgadmin server, the user is not able to modify permissions.
>
> Should pgadmin set permission to key files to 600 or less?
> OR should this be documented as 'Todo' for administrator.
>

If you can detect it's a key reliably, I don't see any reason not to do it
automatically.

--
Dave Page
Blog: https://pgsnake.blogspot.com
Twitter: @pgsnake

EDB: https://www.enterprisedb.com