From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | javib <javier(dot)burgos(at)ricoh(dot)es> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: Creating a new database in pgadmin |
Date: | 2010-03-17 11:38:04 |
Message-ID: | 4BA0BF1C.50009@lelarge.info |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Le 17/03/2010 12:29, javib a écrit :
>
> 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?
>
You should probably look at the manual page for CREATE TABLESPACE:
http://www.postgresql.org/docs/8.4/interactive/sql-createtablespace.html
You need to put in the location field the name of the directory in which
you want to store your database/table. And be sure postgres has
permissions to read/write in this directory.
BTW, you can use pgAdmin to create this tablespace. Could be simpler.
--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2010-03-17 11:39:28 | Re: report generation |
Previous Message | Thom Brown | 2010-03-17 11:37:38 | Re: Creating a new database in pgadmin |