Re: Linux file permission for COPY TO SQL command

From: Krzysztof <kj(at)limes(dot)com(dot)pl>
To: pgsql-sql(at)lists(dot)postgresql(dot)org
Subject: Re: Linux file permission for COPY TO SQL command
Date: 2025-11-02 21:45:51
Message-ID: 5d47fc08-0360-4c08-9051-f6ed424ff61d@limes.com.pl
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

That helped. Thanks.

Pozdrawiam
Krzysztof Jasieński

On 10/29/25 8:55 PM, Tom Lane wrote:
> The /home and /home/kaj directories would also need to be
> world-searchable for the server to be able to write there.
> (Do not make them world-writable...)
>
> Did you notice the HINT that goes with that error message?
>
> HINT: COPY TO instructs the PostgreSQL server process to write a file. You may want a client-side facility such as psql's \copy.
>
> regards, tom lane
>
>

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Nathan Bossart 2025-11-13 16:47:14 Re:   Re: Re: Revoke Connect Privilege from Database not working
Previous Message Roland Müller 2025-10-29 20:11:19 Re: Linux file permission for COPY TO SQL command