From: | Gerd König <koenig(at)transporeon(dot)com> |
---|---|
To: | ria ulfa <riakdr(at)gmail(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: ask...!!! |
Date: | 2008-07-01 09:00:51 |
Message-ID: | 4869F243.8030602@transporeon.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hello,
I don't think it's a good idea to store it under the /root directory,
since "normal" users like e.g. postgres don't have write permission
there (as the error message tells you).
You have to choose a directory where your database user definitely has
write permission.
bye-GERD-
ria ulfa schrieb:
> i use linux fedora 7 and database PostgreSQL 8.
> i want to copy table in postgre to a file.
> i used code : simps=# COPY log TO '/root/documents/log.sql';
> note= simps: name of database
> but there is error: could not open file "/root/documents/log.sql" for
> writing: Permission denied
> what can i do for repair this error??
>
From | Date | Subject | |
---|---|---|---|
Next Message | Glyn Astill | 2008-07-01 09:18:13 | Re: ask...!!! |
Previous Message | ria ulfa | 2008-07-01 08:19:41 | ask...!!! |