Re: [real] Re: copy command problem
| От | Don Isgitt |
|---|---|
| Тема | Re: [real] Re: copy command problem |
| Дата | |
| Msg-id | 3FE0BA5F.3040502@soundenergy.com обсуждение исходный текст |
| Ответ на | copy command problem (Don Isgitt <djisgitt@soundenergy.com>) |
| Список | pgsql-general |
Bernd Helmle wrote: > Don Isgitt wrote: > >> Hi, >> >> gds2=# copy survey_match from '/home/djisgitt/perl/fixsvy.dat' with >> delimiter as '>'; >> ERROR: could not open file "/home/djisgitt/perl/fixsvy.dat" for >> reading: Permission denied >> >> File sysem permissions are >> >> [djisgitt@dbserver perl]$ ls -l /home/djisgitt/perl/fixsvy.dat >> -rwxrwxrwx 1 djisgitt djisgitt 198441 Nov 5 12:35 >> /home/djisgitt/perl/fixsvy.dat >> > > Check, if your home and subdirectories has sufficient permissions: you > need at least r-x for others on the specific directories, otherwise > your backend is not able to access your dump. > > chmod o+rx /home/djisgitt should do the job, i think > > Bernd > > > > Thank you, Bernd; that was the problem. I obviously didn't think about the forest, since the tree was ok. :-[ Don
В списке pgsql-general по дате отправления: