My 1st TABLESPACE

From: Amn Ojee Uw <amnojeeuw(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: My 1st TABLESPACE
Date: 2023-08-07 05:43:55
Message-ID: b73ce442-5a0e-3e0f-626b-bd9906937e8e@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message negora 2023-08-07 05:48:23 Re: My 1st TABLESPACE
Previous Message Ron 2023-08-07 05:19:28 Re: Backup Copy of a Production server.