[postgis-users] Permission denied when trying to create a tablespace in PostgreSQL

Marco Boeringa marco at boeringa.demon.nl
Tue Nov 24 07:26:53 PST 2020

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?


More information about the postgis-users mailing list