On 17 March 2010 11:29, javib
<javier.burgos@ricoh.es> wrote:
Thanks for replying so fast Thom. I tried the following line and it didn't
work:
CREATE TABLESPACE otraParti LOCATION '/media/Iomega HDD(F:)'
and I'm getting the following error:
ERROR: couldn't define permissions for directory «/media/Iomega HDD(F:)»: No
such file or directory
Any ideas?
Is that directory owned by the postgres user? And does it exist at all? If you're using Windows, I'm not sure you can even use tablespaces. The "/media/otherdrive" example was a full path to a destination, so it could be "/mnt/drive/" or "/external" or something like that.
Thom