From: | javib <javier(dot)burgos(at)ricoh(dot)es> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: Creating a new database in pgadmin |
Date: | 2010-03-17 11:51:08 |
Message-ID: | 27930918.post@talk.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
How can I assign permissions to postgress to access the drive?
Thanks!
Guillaume Lelarge-3 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 .
>
>
> --
> Guillaume.
> http://www.postgresqlfr.org
> http://dalibo.com
>
> --
> Sent via pgadmin-support mailing list (pgadmin-support(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support
>
>
--
View this message in context: http://old.nabble.com/Creating-a-new-database-in-pgadmin-tp27930480p27930918.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2010-03-17 12:05:26 | Re: Creating a new database in pgadmin |
Previous Message | Guillaume Lelarge | 2010-03-17 11:40:47 | Re: Creating a new database in pgadmin |