From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | Thom Brown <thombrown(at)gmail(dot)com> |
Cc: | javib <javier(dot)burgos(at)ricoh(dot)es>, pgadmin-support(at)postgresql(dot)org |
Subject: | Re: Creating a new database in pgadmin |
Date: | 2010-03-17 13:56:51 |
Message-ID: | 4BA0DFA3.3000609@lelarge.info |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Le 17/03/2010 13:49, Thom Brown a écrit :
> On 17 March 2010 11:40, Guillaume Lelarge <guillaume(at)lelarge(dot)info> wrote:
>
>> Le 17/03/2010 12:37, Thom Brown a écrit :
>>> 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.
>>>
>>
>> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2010-03-17 13:58:51 | Re: Problem with libpq.so.5 in pgadmin3-1.10.2 |
Previous Message | John Gage | 2010-03-17 13:23:21 | Re: pgAdmin III v1.10.2 released |