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

Re: Creating a new database in pgadmin

From: Thom Brown <thombrown(at)gmail(dot)com>
To: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
Cc: javib <javier(dot)burgos(at)ricoh(dot)es>, pgadmin-support(at)postgresql(dot)org
Subject: Re: Creating a new database in pgadmin
Date: 2010-03-17 12:49:51
Message-ID: bddc86151003170549j375b5f0bl657b464702268c52@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-support
On 17 March 2010 11:40, Guillaume Lelarge <guillaume(at)lelarge(dot)info> 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 .
>
>
Ah, okay.  I was just thrown by the note in the documentation which says,
"Tablespaces are only supported on systems that support symbolic links.".
I'm not sure that's true.

Thom

In response to

Responses

pgadmin-support by date

Next:From: Vinicius BorgesDate: 2010-03-17 13:09:28
Subject: Problem with libpq.so.5 in pgadmin3-1.10.2
Previous:From: javibDate: 2010-03-17 12:13:39
Subject: Re: Creating a new database in pgadmin

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