Bug #9182
closed
Multiple errors "The postgresql process was not running and has been restarted"
Description
Alexis,
As seen on IRC, we have spotted that Rudder checks that its PostgreSQL instance is running through the process list, looking for the postgres: writer process pattern.
(ref: /var/rudder/cfengine-community/inputs/server-roles/1.0/component-check.cf)
But on Debian 8.5 with PostgreSQL 9.5, the writer process appears as postgres: 9.5/main: writer process.
Thanks.
Updated by Alexis Mousset over 7 years ago
- Category set to System techniques
- Target version set to 3.1.15
Jessie repositories contain PostgreSQL 9.4, are you using a package from backports or an external repo?
Updated by Alexandre Anriot over 7 years ago
Hello,
For the record, I have upgraded the Pg cluster to 9.6 and I'm now using:
"service[rudder_reports][binary]" string => "postgres:.*writer process";
Updated by Vincent MEMBRÉ over 7 years ago
- Target version changed from 3.1.15 to 3.1.16
Updated by Vincent MEMBRÉ over 7 years ago
- Target version changed from 3.1.16 to 3.1.17
Updated by Nicolas CHARLES over 7 years ago
- Translation missing: en.field_tag_list set to Sponsored
- Priority changed from N/A to 1
Updated by Nicolas CHARLES over 7 years ago
- Status changed from New to In progress
- Assignee set to Nicolas CHARLES
Updated by Nicolas CHARLES over 7 years ago
a postgres 9.6, from the postgresql official repo, has the following string
postgres: 9.6/main: writer process
Updated by Nicolas CHARLES over 7 years ago
- Status changed from In progress to Pending technical review
- Assignee changed from Nicolas CHARLES to Alexis Mousset
- Pull Request set to https://github.com/Normation/rudder-techniques/pull/1087
Updated by Nicolas CHARLES over 7 years ago
- Status changed from Pending technical review to Pending release
- % Done changed from 0 to 100
Applied in changeset rudder-techniques|be7907be41a8f61ad6b0786dc9df4be3baa8db3c.
Updated by Vincent MEMBRÉ over 7 years ago
- Status changed from Pending release to Released
Updated by Nicolas CHARLES almost 5 years ago
- Related to Bug #14742: System technique don't support PostgreSQL from other source than the distribution added