Skip site navigation (1) Skip section navigation (2)

Re: Creating a new database in pgadmin

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: (view raw, whole thread or download thread mbox)
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:

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.


In response to

pgadmin-support by date

Next:From: Guillaume LelargeDate: 2010-03-17 11:39:28
Subject: Re: report generation
Previous:From: Thom BrownDate: 2010-03-17 11:37:38
Subject: Re: Creating a new database in pgadmin

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group