Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1vFftn-00GHuc-9Y for pgsql-sql@arkaria.postgresql.org; Sun, 02 Nov 2025 21:46:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1vFftk-00ERcW-4k for pgsql-sql@arkaria.postgresql.org; Sun, 02 Nov 2025 21:46:03 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1vFftj-00ERcN-SW for pgsql-sql@lists.postgresql.org; Sun, 02 Nov 2025 21:46:02 +0000 Received: from deimos.limes.com.pl ([193.110.228.48]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vFftg-005dZI-0I for pgsql-sql@lists.postgresql.org; Sun, 02 Nov 2025 21:46:02 +0000 Received: from localhost (localhost [127.0.0.1]) by deimos.limes.com.pl (Postfix) with ESMTP id 120BA251207D for ; Sun, 2 Nov 2025 22:45:54 +0100 (CET) X-Virus-Scanned: Debian amavisd-new at deimos.limes.com.pl X-Spam-Flag: NO X-Spam-Score: -3.027 X-Spam-Level: X-Spam-Status: No, score=-3.027 tagged_above=-9999 required=6.11 tests=[ALL_TRUSTED=-1, AWL=-0.117, BAYES_00=-1.9, T_SCC_BODY_TEXT_LINE=-0.01] autolearn=ham autolearn_force=no Received: from deimos.limes.com.pl ([127.0.0.1]) by localhost (deimos.limes.com.pl [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id C-yJY52D8uOV for ; Sun, 2 Nov 2025 22:45:52 +0100 (CET) Received: from [192.168.51.220] (host141-89-206-34.limes.com.pl [89.206.34.141]) by deimos.limes.com.pl (Postfix) with ESMTPA id EC6E52512078 for ; Sun, 2 Nov 2025 22:45:51 +0100 (CET) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=limes.com.pl; s=mail; t=1762119951; bh=MNCiWquFo0dgpYjxCXG8TdR4Kl6L5N776sfe5wEDHnQ=; h=Date:Subject:To:References:From:In-Reply-To; b=Hh80xPa+lsbqBycT/JaBaEnwQIlSRENkU3YeriVRa1wCqKu660DuOGUo2F1Nzae5G osWJT6j/0kr5kWX8mtflnlw0AWOWZwCxdzxH/+2Oc4BCxRHu+dD6Ph1fxuDMnH7iJt aB2xq6s6ABz1PRmzhh/4evExP4xLg/BaAtzdcJac6kQcwY7i1FqQgdvfuFVi3ZlUqq Pr87RgXCGGIG59Q638FBhQBiFWWP7jR0QyZdFIDuKloDO5MnKcAZXxC1l5nv1GA9pS xpPbN/L8dV8E2uF9n8skKyAwDRLFlFu98+JqRBC2m0dyUt4lvJTf3Ke7Pm7WtHAAhu kCPmBBD7TDGcQ== Message-ID: <5d47fc08-0360-4c08-9051-f6ed424ff61d@limes.com.pl> Date: Sun, 2 Nov 2025 22:45:51 +0100 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Linux file permission for COPY TO SQL command To: pgsql-sql@lists.postgresql.org References: <8ABD45BB-37B7-4394-AB59-10BC1C25797F@gmail.com> <7d2f7e34-c724-4227-a1c2-8d5882a6a3d4@gmail.com> <2892301.1761767753@sss.pgh.pa.us> Content-Language: en-US From: Krzysztof In-Reply-To: <2892301.1761767753@sss.pgh.pa.us> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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 > >