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.
