On Mon, Aug 7, 2023 at 5:47 PM Amn Ojee Uw <amnoje...@gmail.com> 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 > <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';* > > 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. > > >
