MIME-Version: 1.0 (Mimestream 1.9.11)
From: Anthony DeBarros <anthonymdebarros@gmail.com>
Date: Fri, 13 Feb 2026 13:14:50 -0800
Message-ID: <CACJO+64KDa_NbodkZ-OGQ0uBVVQ5kksOBUB_tm3dZ_D=tFHxvA@mail.gmail.com>
Subject: Best practice for granting folder read/write permission on Windows
To: pgsql-general@postgresql.org
Content-Type: multipart/alternative; boundary="00000000000092785a064abb18e8"
Archived-At: <https://www.postgresql.org/message-id/CACJO%2B64KDa_NbodkZ-OGQ0uBVVQ5kksOBUB_tm3dZ_D%3DtFHxvA%40mail.gmail.com>
Precedence: bulk

--00000000000092785a064abb18e8
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi, all,

I don=E2=80=99t use Windows much, but I often help folks who do and are lea=
rning
SQL by running PostgreSQL on that OS.

In order to COPY FROM or TO a folder on, say, the Desktop, the user must
first provide permission to PostgreSQL to Read and Write from it. Out of
the box, it cannot as it does not have permission.

Do any of you with PostgreSQL and Windows expertise have a suggestion on a
best practice for this? I have through trial and error found that
navigating to the folder Properties, and then Security, and adding =E2=80=
=9CUsers=E2=80=9D
to the list of Group or user names solves the issue. I suppose I could find
the specific name of the PostgreSQL service and add it, but that=E2=80=99s =
a lot of
digging for newbies.

I hope this question is clear. Thanks for any suggestions.

Anthony DeBarros

--00000000000092785a064abb18e8
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<html><body><div dir=3D"ltr">Hi, all,<div><br></div><div dir=3D"ltr">I don=
=E2=80=99t use Windows much, but I often help folks who do and are learning=
 SQL by running PostgreSQL on that OS.=C2=A0</div><div dir=3D"ltr"><br></di=
v><div dir=3D"ltr">In order to COPY FROM or TO a folder on, say, the Deskto=
p, the user must first provide permission to PostgreSQL to Read and Write f=
rom it. Out of the box, it cannot as it does not have permission.</div><div=
 dir=3D"ltr"><br></div><div dir=3D"ltr">Do any of you with PostgreSQL and W=
indows expertise have a suggestion on a best practice for this? I have thro=
ugh trial and error found that navigating to the folder Properties, and the=
n Security, and adding =E2=80=9CUsers=E2=80=9D to the list of Group or user=
 names solves the issue. I suppose I could find the specific name of the Po=
stgreSQL service and add it, but that=E2=80=99s a lot of digging for newbie=
s.</div><div dir=3D"ltr"><br></div><div dir=3D"ltr">I hope this question is=
 clear. Thanks for any suggestions.</div><div dir=3D"ltr"><br></div><div di=
r=3D"ltr">Anthony DeBarros=C2=A0</div></div></body></html>

--00000000000092785a064abb18e8--