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? Thom Brown wrote: > > On 17 March 2010 11:10, javib <javier.bur...@ricoh.es> 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'm going to create will be huge and I need lots of space. >> Can anyone help me with this issue?? >> >> Thanks in advance. >> Best regards >> -- >> >> > You will need to create a new tablespace onto the other hard drive then > create the database using that tablespace: > > For example: > > CREATE TABLESPACE new_space LOCATION '/media/otherdrive'; > > CREATE DATABASE new_db TABLESPACE new_space; > > Regards > > Thom > > -- View this message in context: http://old.nabble.com/Creating-a-new-database-in-pgadmin-tp27930480p27930670.html Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com. -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
