public inbox for [email protected]  

help / color / mirror / Atom feed

From: Tom Lane <[email protected]>
To: Johan Antonissen <[email protected]>
Cc: [email protected]
Subject: Re:
Date: Mon, 17 Apr 2023 09:54:11 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAEac0YaJuyWc=7Rc6kWf6hEphD-s76Ge2Q01hiAo_7rtS1YJ6w@mail.gmail.com>
References: <CAEac0YaJuyWc=7Rc6kWf6hEphD-s76Ge2Q01hiAo_7rtS1YJ6w@mail.gmail.com>

Johan Antonissen <[email protected]> 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

view thread (4+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re:
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox