From: Tom Lane <tgl@sss.pgh.pa.us>
To: Krzysztof <kj@limes.com.pl>
cc: pgsql-sql@lists.postgresql.org
Subject: Re: Linux file permission for COPY TO SQL command
In-reply-to: <bed776bc-f63d-46f5-8bb0-840493aab3df@limes.com.pl>
References: <f1072845-ca23-46de-bbf2-41acbae3a97e@limes.com.pl>
 <8ABD45BB-37B7-4394-AB59-10BC1C25797F@gmail.com>
 <7d2f7e34-c724-4227-a1c2-8d5882a6a3d4@gmail.com>
 <bed776bc-f63d-46f5-8bb0-840493aab3df@limes.com.pl>
Comments: In-reply-to Krzysztof <kj@limes.com.pl>
	message dated "Wed, 29 Oct 2025 19:44:01 +0100"
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-ID: <2892300.1761767753.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Wed, 29 Oct 2025 15:55:53 -0400
Message-ID: <2892301.1761767753@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/2892301.1761767753%40sss.pgh.pa.us>
Precedence: bulk

Krzysztof <kj@limes.com.pl> writes:
> Actually server and client are installed on the same machine.
> The file (real file) permissions are as follows:

> -rwxrwxrwx+ 1 kaj kaj 2 Oct 27 22:36 fd/fdo.txt

> The directory permissions are as follows:

> drwxrwxrwx+ =C2=A04 kaj kaj =C2=A0=C2=A0=C2=A0=C2=A04096 Oct 27 22:36 fd

> The SQL command which tries to write to the file is this:

> copy (select key from xcg where add=3Dfalse) to '/home/kaj/fd/fdo.txt';

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. Yo=
u may want a client-side facility such as psql's \copy.

			regards, tom lane