Re: archive command Permission Denied?

Поиск
Список
Период
Сортировка
От Jason Long
Тема Re: archive command Permission Denied?
Дата
Msg-id 4914E281.7040208@supernovasoftware.com
обсуждение исходный текст
Ответ на Re: archive command Permission Denied?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: archive command Permission Denied?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Tom Lane wrote:
Jason Long <mailing.list@supernovasoftware.com> writes: 
Tom Lane wrote:   
If that is what's happening, you'll find "avc denied" messages in the
system log that correlate to the archive failures.
     
*I did not see anything like this in my logs.*   
You'd need to look in the system log (/var/log/messages) not the
postmaster's log. 
I think I found the problem.  By putting the archive command directly in postgresql.conf

I got this error

/usr/sbin/sendmail: Permission denied

So I guess I need to allow the use of sendmail.

How is postgres running the command different from my doing it as the postgres user or cron running as the postgres user?

Oh, well time to call my Linux guru.  Thanks for all your help.  You definitely got me going tin the right direction.

		regards, tom lane 

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Specifying text to substitute for NULLs in selects
Следующее
От: Tom Allison
Дата:
Сообщение: Re: postgresql and Mac OS X