Search Postgresql Archives

My 1st TABLESPACE

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux