Re: archive command Permission Denied? - Mailing list pgsql-general

From Jason Long
Subject Re: archive command Permission Denied?
Date
Msg-id 4914E281.7040208@supernovasoftware.com
Whole thread Raw
In response to Re: archive command Permission Denied?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: archive command Permission Denied?
List 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 by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Specifying text to substitute for NULLs in selects
Next
From: Tom Allison
Date:
Subject: Re: postgresql and Mac OS X