Re: Creating a new database in pgadmin

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.