Re: [pgadmin-support] Creating a new database in pgadmin

2010-03-17 Thread Guillaume Lelarge
Le 17/03/2010 13:49, Thom Brown a écrit : > On 17 March 2010 11:40, Guillaume Lelarge wrote: > >> Le 17/03/2010 12:37, Thom Brown a écrit : >>> On 17 March 2010 11:29, javib wrote: >>> Thanks for replying so fast Thom. I tried the following line and it >> didn't work: CR

Re: [pgadmin-support] Creating a new database in pgadmin

2010-03-17 Thread Thom Brown
On 17 March 2010 11:40, Guillaume Lelarge wrote: > Le 17/03/2010 12:37, Thom Brown a écrit : > > On 17 March 2010 11:29, javib wrote: > > > >> > >> Thanks for replying so fast Thom. I tried the following line and it > didn't > >> work: > >> > >> CREATE TABLESPACE otraParti LOCATION '/media/Iomeg

Re: [pgadmin-support] Creating a new database in pgadmin

2010-03-17 Thread javib
Thanks!! It works now. My OS is windows. I've created the new tablespace with the pgadmin following the instructions and works fine!! Thanks againn Guillaume Lelarge-3 wrote: > > Le 17/03/2010 12:51, javib a écrit : >> >> How can I assign permissions to postgress to access the drive? > > Depe

Re: [pgadmin-support] Creating a new database in pgadmin

2010-03-17 Thread Guillaume Lelarge
Le 17/03/2010 12:51, javib a écrit : > > How can I assign permissions to postgress to access the drive? Depends on you operating system, which you still haven't told us. I suppose this is on Windows. Right click on your directory, choose Properties, click on the Security tab, check if the postgre

Re: [pgadmin-support] Creating a new database in pgadmin

2010-03-17 Thread javib
How can I assign permissions to postgress to access the drive? Thanks! Guillaume Lelarge-3 wrote: > > Le 17/03/2010 12:37, Thom Brown a écrit : >> On 17 March 2010 11:29, javib wrote: >> >>> >>> Thanks for replying so fast Thom. I tried the following line and it >>> didn't >>> work: >>> >>> CR

Re: [pgadmin-support] Creating a new database in pgadmin

2010-03-17 Thread Guillaume Lelarge
Le 17/03/2010 12:37, Thom Brown a écrit : > On 17 March 2010 11:29, javib 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: coul

Re: [pgadmin-support] Creating a new database in pgadmin

2010-03-17 Thread Guillaume Lelarge
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

Re: [pgadmin-support] Creating a new database in pgadmin

2010-03-17 Thread Thom Brown
On 17 March 2010 11:29, javib 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 H

Re: [pgadmin-support] Creating a new database in pgadmin

2010-03-17 Thread javib
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? Tho

Re: [pgadmin-support] Creating a new database in pgadmin

2010-03-17 Thread Thom Brown
On 17 March 2010 11:10, javib 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'

[pgadmin-support] Creating a new database in pgadmin

2010-03-17 Thread javib
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 sp

[pgadmin-support] Creating a new database in pgadmin

2010-03-17 Thread javib
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 sp