Hi all,
More of a general postgresql question:
It is quite a bit of time ago since I last did this, but I am in the
process of rebuilding an Ubuntu 20.4.x virtual machine. Now I
succesfully installed PostgreSQL 13.1 + PostGIS 3, but I want to add
dedicated tablespaces for data + indexes, to spread the IO load related
to the large amount of GIS data.
I have successfully added the two physical drives to my (Hyper-V based)
Ubuntu VM, mounted them to media/<user_name>/<subfolder1/2> and set the
permissions on the "subfolder1" and "subfolder2" to allow the
"PostgreSQL administrator" user full control ("Create and delete
files"). The same for the "group" postgres.
I rebooted the VM, and restarted the postgresql service.
Still, when I try to finally create the actual tablespace using
pgAdmin4, I get a "Permission denied" type error ("ERROR: could not set
permissions on directory").
I remember struggling with this before the last time I recreated a VM
from scratch, but can't remember what I did to finally solve this...
Anyone a hint to what I missed?
Marco
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users