Re: Why are there pg_dump errors in my Apache httpd error_log ? (Postgres 8.3.7 on CentOS 5)

Aleksey Tsalolikhin wrote:
> Hi.  I just found pg_dump errors in my Apache httpd log and am really
> confused.   Has anybody seen this before?
>
> My syslog.conf does not mention the httpd error_log.
>
> How did the errors get in there?
>
> # grep pg_dump /var/log/httpd/error_log
> pg_dump: [archiver] could not open output file: Permission denied
> pg_dump: [archiver] could not open output file: Permission denied
> pg_dump: [archiver] could not open output file: Permission denied
> pg_dump: [archiver] could not open output file: Permission denied
> pg_dump: server version: X.X.X; pg_dump version: Y.Y.Y
> pg_dump: aborting because of version mismatch  (Use the -i option to
> proceed anyway.)
>
These are definitely outputs from phppgadmin.  When you run an export in
that application, it uses pg_dump if it's found.  It looks like it's
finding it with a different version that the server it's dumping from.
I can't remember under what circumstances it writes files to disk, but
it's trying that and denied the privilege.

Regards

Russell