On 17 March 2010 11:29, javib <javier(dot)burgos(at)ricoh(dot)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