On 17 March 2010 11:10, javib <javier(dot)burgos(at)ricoh(dot)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