From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | cen <imbacen(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Weird periodical pg log |
Date: | 2017-05-19 13:57:20 |
Message-ID: | b3aa7575-f497-060a-3a6a-6e601e0e77ef@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 05/19/2017 01:25 AM, cen wrote:
> Every single day at exactly the same hour I get this in my pg_log:
>
>
> < 2017-05-15 17:00:29.517 CEST >FATAL: pg_hba.conf rejects connection
> for host "...", user "postgres", database "template1", SSL off
> < 2017-05-15 17:00:29.571 CEST >WARNING: archive_mode enabled, yet
> archive_command is not set
> < 2017-05-15 17:00:41.859 CEST >LOG: received SIGHUP, reloading
> configuration files
> < 2017-05-15 17:00:41.861 CEST >LOG: parameter "archive_command"
> changed to ""/opt/omni/lbin/pgsqlbar.exe" -stage %p -backup"
Per Karsten's suggestion, the above seems to come from HP Enterprise
software. As a start I would see what pgsqlbar.exe -help says.
> < 2017-05-15 17:00:51.865 CEST >LOG: received SIGHUP, reloading
> configuration files
> < 2017-05-15 17:00:51.867 CEST >LOG: parameter "archive_command"
> removed from configuration file, reset to default
>
>
> Postgres 9.5 is running on Centos 7. I checked all cron jobs and
> scripts, there is nothing external that would cause this so my guess is
> that this is internal Postgres cron job tryin to do "something", I just
> don't know what exactly.
It is not an internal Postgres job. Something external to Postgres is
making a change to postgresql.conf reloading the server conf files,
undoing the change and then reloading the server conf files again.
>
> We have WAL replication set up, these logs appear on master. Perhaps we
> have something off in our conf?
>
>
> Best regards, cen
>
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | John R Pierce | 2017-05-19 14:10:17 | Re: Weird periodical pg log |
Previous Message | bb ddd | 2017-05-19 13:30:18 | Keeping sources of views, and tracking invalid objects (views) similar to oracle |