pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Glyn Astill <glynastill@yahoo.co.uk>
To: ria ulfa <riakdr@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: ask...!!!
Date: Tue, 1 Jul 2008 09:18:13 +0000 (GMT)
Message-ID: <154381.76536.qm@web25805.mail.ukl.yahoo.com> (raw)

You need to output it into a directory you have permission to write to.
Either change the permissions on documents, or write it into somewhere
you definately do have permissions (e.g. /tmp/log.sql) and then move it
to the desired location.


----- Original Message ----
From: ria ulfa <riakdr@gmail.com>
To: pgsql-admin@postgresql.org
Sent: Tuesday, 1 July, 2008 9:19:41 AM
Subject: [ADMIN] ask...!!!



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



      __________________________________________________________
Not happy with your email address?.
Get the one you really want - millions of new email addresses available now at Yahoo! http://uk.docs.yahoo.com/ymail/new.html

view thread (8+ messages)  latest in thread

Message-ID: <154381.76536.qm@web25805.mail.ukl.yahoo.com>
Permalink:  ../154381.76536.qm@web25805.mail.ukl.yahoo.com/
Also on:    postgresql.org/message-id/154381.76536.qm@web25805.mail.ukl.yahoo.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: glynastill@yahoo.co.uk, riakdr@gmail.com
  Subject: Re: ask...!!!
  In-Reply-To: <154381.76536.qm@web25805.mail.ukl.yahoo.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox