Re: ask...!!!

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??
>

In response to

  • ask...!!! at 2008-07-01 08:12:39 from ria ulfa

Browse pgsql-admin by date

  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...!!!