Search Postgresql Archives

Re: Weird periodical pg log

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux