Page 1 of 1

Placing the database on an external database

PostPosted: Thu Oct 02, 2008 5:36 pm
by Perrygarl
Having problems placing the database onto a external hard drive, wonder if any of you could help me.

I have started the "pqsl" to, to open up the command prompt:, but as I place" CREATE TABLESPACE spare_disk LOCATION 'F:\\pg_data'; (the drive for me is F, not D) into the command prompt, I get this message

ERROR: Could not set permissions on directory "F:/pg_data": Permission denied postgres=#

I am using XP Home

Can anyone help me, on how to solve this problem?

highfalutin