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.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general