I'd like to create a TABLESPACE, so, following
this web page, 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.