Search Postgresql Archives

Re: My 1st TABLESPACE

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

 




On Mon, Aug 7, 2023 at 5:47 PM Amn Ojee Uw <amnojeeuw@xxxxxxxxx> wrote:

Thanks Negora.

Makes sense, I will check it out.

On 8/7/23 1:48 a.m., negora wrote:

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,  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';


Here owner is jme   and the  data dir  you created must have owner jme.. 

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