79544151

Date: 2025-03-30 03:19:53
Score: 1.5
Natty:
Report link

I work in Debian, and I add "postgres" user to "myuser"'s group that own the folder:

usermod -a -G myuser postgres

then I use chmod for give access to the user of the group, and create the table space folder

chmod 775 /home/myuser

su postgres

mkdir /home/myuser/ . . . /TableSpaceFolder

and finally use the command in "psql"

postgres=# create tablespace ts_name owner role_name location '/home/mysuer/ . . . /TableSapaceFolder';

CREATE TABLESPACE

Work for me.

Reasons:
  • No code block (0.5):
  • Low reputation (1):
Posted by: Lucio Miguel Cortés Villarroel