Le 17/03/2010 13:49, Thom Brown a écrit : > 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. >
It's true. It basically means you cannot use tablespace on Windows NT4. Other Windows NT (2000, XP, 2003, Vista, 2008, 7) don't have this issue. (Dave / Magnus, correct me if I say stupid things :) ) -- Guillaume. http://www.postgresqlfr.org http://dalibo.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
