pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: negora <public@negora.com>
To: pgsql-general@lists.postgresql.org
Subject: Re: My 1st TABLESPACE
Date: Mon, 7 Aug 2023 07:48:23 +0200
Message-ID: <52ffd5a0-89b2-931d-f135-cbd65027eb28@negora.com> (raw)
In-Reply-To: <b73ce442-5a0e-3e0f-626b-bd9906937e8e@gmail.com>
References: <b73ce442-5a0e-3e0f-626b-bd9906937e8e@gmail.com>

Hi:

Although the "postgres" user owns the "data" directory, Has he access to 
the whole branch of directories? Maybe the problem is that he can't 
reach the "data" directory.

Regards.


On 07/08/2023 07:43, Amn Ojee Uw wrote:
>
> I'd like to create a TABLESPACE, so, following this web page 
> <https://www.postgresql.org/docs/current/sql-createtablespace.html>,  
> I have done the following :
>
> *mkdir 
> /home/my_debian_account/Documents/NetbeansWorkSpace/JavaSE/Jme/database/postgresql/data*
>
> *sudo chown postgres:postgres 
> /home/my_debian_account/Documents/NetbeansWorkSpace/JavaSE/Jme/database/postgresql/data*
>
> *sudo -u postgres psql*
>
> *\du**
> ** arbolone    | Cannot login                                      | {}**
> ** chispa |                                                            
> | {prosafe}**
> ** workerbee | Superuser, Create DB | {arbolone}**
> ** jme |                                                            | 
> {arbolone}**
> ** postgres    | Superuser, Create role, Create DB, Replication, 
> Bypass RLS | {}**
> ** prosafe      | Cannot login                                      | {}**
> ****
> **CREATE TABLESPACE jmetablespace OWNER jme LOCATION 
> '/home/my_debian_account/Documents/NetbeansWorkSpace/JavaSE/Jme/database/postgresql/data';*
>
> The *CREATE **TABLESPACE* schema throws this error message :
>
> /*ERROR:  could not set permissions on directory 
> "/home/my_debian_account/Documents/NetbeansWorkSpace/JavaSE/Jme/database/postgresql/data": 
> Permission denied*/
>
> I have followed the web page to the best of my abilities, and AFAIK, 
> the postgres user owns the folder '*data*'.
>
> I know that something is missing, where did I go wrong and how can I 
> resolve this issue?
>
>
> Thanks in advance.
>
>

view thread (4+ messages)  latest in thread

Message-ID: <52ffd5a0-89b2-931d-f135-cbd65027eb28@negora.com>
Permalink:  ../52ffd5a0-89b2-931d-f135-cbd65027eb28@negora.com/
Also on:    postgresql.org/message-id/52ffd5a0-89b2-931d-f135-cbd65027eb28@negora.com

 · 

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-general@postgresql.org
  Cc: public@negora.com
  Subject: Re: My 1st TABLESPACE
  In-Reply-To: <52ffd5a0-89b2-931d-f135-cbd65027eb28@negora.com>
  References: <b73ce442-5a0e-3e0f-626b-bd9906937e8e@gmail.com> <52ffd5a0-89b2-931d-f135-cbd65027eb28@negora.com>

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

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