Placing the database on an external database

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

Placing the database on an external database

Postby Perrygarl » Thu Oct 02, 2008 5:36 pm

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?
Perrygarl
 
Posts: 4
Joined: Tue Jun 24, 2008 6:52 pm

Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 22 guests

cron