COPY ... FROM Permission denied ...

Поиск
Список
Период
Сортировка
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


Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: pg_restore question (-T and -t)
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: Re: Vacuum problems