On 17 March 2010 11:40, Guillaume Lelarge
<guillaume@lelarge.info> wrote:
Le 17/03/2010 12:37, Thom Brown a écrit :
> 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.
>
You can use tablespaces on Windows. It won't be a /media/something path
though. It will probably be something like F:/path/to/my/directory .
Ah, okay. I was just thrown by the note in the documentation which says, "Tablespaces are only supported on systems that support symbolic links.". I'm not sure that's true.
Thom