On 17 March 2010 11:40, Guillaume Lelarge <guilla...@lelarge.info> wrote:
> Le 17/03/2010 12:37, Thom Brown a écrit : > > 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. > > > > 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
