archive command Permission Denied?

From: Jason Long <mailing(dot)list(at)supernovasoftware(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: archive command Permission Denied?
Date: 2008-11-07 21:55:20
Message-ID: 4914B948.1020606@supernovasoftware.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Please bear with me. I am fairly new to Linux.

I am working on archiving my WAL files. For now I am just mailing
myself a list of the directory contents using the following script.

*-rwxr-xr-x 1 postgres postgres 87 Oct 28 20:23
/var/lib/pgsql/mail-WAL-list.sh*

the contents are simply

*ls -lrt /var/lib/pgsql/data/pg_xlog/ | mail -s "WAL files are:"
myemail(at)mydomain(dot)com*

I also have this set up to run in the postgres users cron at 8 a.m.

I can run this when logged on as postgres and the cron runs fine as
well, but I keep seeing the following in my logs.

*LOG: archive command failed with exit code 126
DETAIL: The failed archive command was: /var/lib/pgsql/mail-WAL-list.sh
WARNING: transaction log file "0000000100000000000000F0" could not be
archived: too many failures
sh: /var/lib/pgsql/mail-WAL-list.sh: Permission denied*

I would appreciate any advice on what permission I need to set in order
for this command to run.

--
Thank you for your time,

Jason Long
CEO and Chief Software Engineer
BS Physics, MS Chemical Engineering
http://www.octgsoftware.com
HJBug Founder and President
http://www.hjbug.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mike Toews 2008-11-07 22:04:53 Re: Specifying text to substitute for NULLs in selects
Previous Message Mike Toews 2008-11-07 21:32:45 Re: Specifying text to substitute for NULLs in selects