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:29:34 |
Message-ID: | 27930670.post@talk.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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?
Thom Brown wrote:
>
> On 17 March 2010 11:10, javib <javier(dot)burgos(at)ricoh(dot)es> wrote:
>
>>
>> Hello,
>> I would like to create a database in a different hard drive than the one
>> in
>> which pgadmin is installed. I've been looking through the options of
>> pgadmin
>> and I haven't seen anything. The reason I'm doing this is because this
>> new
>> database I'm going to create will be huge and I need lots of space.
>> Can anyone help me with this issue??
>>
>> Thanks in advance.
>> Best regards
>> --
>>
>>
> You will need to create a new tablespace onto the other hard drive then
> create the database using that tablespace:
>
> For example:
>
> CREATE TABLESPACE new_space LOCATION '/media/otherdrive';
>
> CREATE DATABASE new_db TABLESPACE new_space;
>
> Regards
>
> Thom
>
>
--
View this message in context: http://old.nabble.com/Creating-a-new-database-in-pgadmin-tp27930480p27930670.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2010-03-17 11:31:49 | Re: Graphical Query Builder - usage stats? |
Previous Message | Guillaume Lelarge | 2010-03-17 11:29:30 | Re: pgAdmin III v1.10.2 released |