Re: [GENERAL] Weird periodical pg log

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@aklaver.com