Postgres Pro
Downloads
Home   >   mailing lists

COPY ... FROM Permission denied ... - Mailing list pgsql-general

From Pedro Doria Meunier
Subject COPY ... FROM Permission denied ...
Date
Msg-id 200901061841.50818.pdoria@netmadeira.com
Whole thread Raw
Responses Re: COPY ... FROM Permission denied ...  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Re: COPY ... FROM Permission denied ...  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: COPY ... FROM Permission denied ...  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-general
Tree view 
Hi All,

This is a bit embarassing ... but ...

I have a partial set of data that I want to restore via COPY ... FROM command

I have created a public folder for the effect and chown'ed both the folder and
the file to be fed into COPY to a+rw ...

I switched users with su - postgres and connected to the DB with the psql
command

All I'm getting is a Permission denied upon issuing the COPY command from
within psql interactive terminal! :O

So:
a) The Christmas *spirits* killed a billion of my brain cells
b) I need to go to postgresql kindergarden
c) I'm missing something very basic

Could someone please lend a hand?

Thanks in advance,

Pedro Doria Meunier
GSM: +351961720188
Skype: pdoriam
Attachment

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pg_restore question (-T and -t)
Next
From: "Scott Marlowe"
Date:
Subject: Re: Vacuum problems