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