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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Vinicius Borges | 2010-03-17 13:09:28 | Problem with libpq.so.5 in pgadmin3-1.10.2 |
Previous Message | javib | 2010-03-17 12:13:39 | Re: Creating a new database in pgadmin |