On 17 March 2010 11:29, javib <javier.bur...@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