Re: Creating a new database in pgadmin

<div class="gmail_quote">On 17 March 2010 11:29, javib <span dir="ltr"><<a
href="mailto:javier.burgos@ricoh.es">javier.burgos@ricoh.es</a>></span>wrote:<br /><blockquote class="gmail_quote"
style="margin:0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><br /> Thanks for
replyingso fast Thom. I tried the following line and it didn't<br /> work:<br /><br /> CREATE TABLESPACE otraParti
LOCATION'/media/Iomega HDD(F:)'<br /><br /> and I'm getting the following error:<br /> ERROR: couldn't define
permissionsfor directory «/media/Iomega HDD(F:)»: No<br /> such file or directory<br /><br /> Any ideas?<br
/></blockquote></div><br/><br />Is that directory owned by the postgres user?  And does it exist at all?  If you're
usingWindows, I'm not sure you can even use tablespaces.  The "/media/otherdrive" example was a full path to a
destination,so it could be "/mnt/drive/" or "/external" or something like that.<br /><br />Thom<br />