MIME-Version: 1.0
References: 
 <CAEac0YaJuyWc=7Rc6kWf6hEphD-s76Ge2Q01hiAo_7rtS1YJ6w@mail.gmail.com>
 <2416657.1681739651@sss.pgh.pa.us>
In-Reply-To: <2416657.1681739651@sss.pgh.pa.us>
From: Josh Innis <joshinnis@gmail.com>
Date: Tue, 18 Apr 2023 00:46:34 +0900
Message-ID: 
 <CAAZtsUqeyYTKy8S0DNJxagAC5=rivUdiWTGsYUkni5eRYhjeHw@mail.gmail.com>
Subject: Re:
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Johan Antonissen <windhoos@gmail.com>, pgsql-novice@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000001ad36f05f98a1965"
Archived-At: 
 <https://www.postgresql.org/message-id/CAAZtsUqeyYTKy8S0DNJxagAC5%3DrivUdiWTGsYUkni5eRYhjeHw%40mail.gmail.com>
Precedence: bulk

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

+1

On Mon, Apr 17, 2023 at 10:54=E2=80=AFPM Tom Lane <tgl@sss.pgh.pa.us> wrote=
:

> Johan Antonissen <windhoos@gmail.com> writes:
> > However when I try to deploy django and connect to my postgres server
> > postgres gives me a permission error:
>
> > python manage.py sqlcreate | sudo -u postgres psql -U postgres
>
> > results to:
>
> > Could not change directory ... permission deniedCREATE ROLECREATE
> DATABASEGRANT
>
> The "Could not change directory ... permission denied" part is mostly
> cosmetic.  It happens when psql is invoked in a current working
> directory that the postgres user can't read.  The fact that you're
> getting "CREATE ROLE", "CREATE DATABASE", etc command completion
> acknowledgements indicates that the SQL script is executing
> successfully anyway.  So what you've showed us doesn't really
> indicate that anything is wrong; although you could try it from
> a publicly-readable starting directory if you want to be sure.
>
>                         regards, tom lane
>
>
>

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

<div dir=3D"ltr">+1<br></div><br><div class=3D"gmail_quote"><div dir=3D"ltr=
" class=3D"gmail_attr">On Mon, Apr 17, 2023 at 10:54=E2=80=AFPM Tom Lane &l=
t;<a href=3D"mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us</a>&gt; wrote:<br>=
</div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;b=
order-left:1px solid rgb(204,204,204);padding-left:1ex">Johan Antonissen &l=
t;<a href=3D"mailto:windhoos@gmail.com" target=3D"_blank">windhoos@gmail.co=
m</a>&gt; writes:<br>
&gt; However when I try to deploy django and connect to my postgres server<=
br>
&gt; postgres gives me a permission error:<br>
<br>
&gt; python manage.py sqlcreate | sudo -u postgres psql -U postgres<br>
<br>
&gt; results to:<br>
<br>
&gt; Could not change directory ... permission deniedCREATE ROLECREATE DATA=
BASEGRANT<br>
<br>
The &quot;Could not change directory ... permission denied&quot; part is mo=
stly<br>
cosmetic.=C2=A0 It happens when psql is invoked in a current working<br>
directory that the postgres user can&#39;t read.=C2=A0 The fact that you=
9;re<br>
getting &quot;CREATE ROLE&quot;, &quot;CREATE DATABASE&quot;, etc command c=
ompletion<br>
acknowledgements indicates that the SQL script is executing<br>
successfully anyway.=C2=A0 So what you&#39;ve showed us doesn&#39;t really<=
br>
indicate that anything is wrong; although you could try it from<br>
a publicly-readable starting directory if you want to be sure.<br>
<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 regards, tom lane<br>
<br>
<br>
</blockquote></div>

--0000000000001ad36f05f98a1965--