Project

General

Profile

Actions

Bug #9182

closed

Multiple errors "The postgresql process was not running and has been restarted"

Added by Alexandre Anriot over 4 years ago. Updated over 4 years ago.

Status:
Released
Priority:
1
Category:
System techniques
Target version:
Severity:
User visibility:
Effort required:
Priority:
Tags:

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.


Related issues

Related to Rudder - Bug #14742: System technique don't support PostgreSQL from other source than the distributionReleasedBenoît PECCATTEActions
Actions #1

Updated by Alexis MOUSSET over 4 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?

Actions #2

Updated by Alexandre Anriot over 4 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";

Actions #3

Updated by Vincent MEMBRÉ over 4 years ago

  • Target version changed from 3.1.15 to 3.1.16
Actions #4

Updated by Vincent MEMBRÉ over 4 years ago

  • Target version changed from 3.1.16 to 3.1.17
Actions #5

Updated by Nicolas CHARLES over 4 years ago

  • Tags set to Sponsored
  • Priority changed from N/A to 1
Actions #6

Updated by Nicolas CHARLES over 4 years ago

  • Status changed from New to In progress
  • Assignee set to Nicolas CHARLES
Actions #7

Updated by Nicolas CHARLES over 4 years ago

a postgres 9.6, from the postgresql official repo, has the following string

postgres: 9.6/main: writer process

Actions #8

Updated by Nicolas CHARLES over 4 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
Actions #9

Updated by Nicolas CHARLES over 4 years ago

  • Status changed from Pending technical review to Pending release
  • % Done changed from 0 to 100
Actions #10

Updated by Vincent MEMBRÉ over 4 years ago

  • Status changed from Pending release to Released

This bug has been fixed in Rudder 4.0.1, 3.1.16 and 3.2.10 which were released today.

Actions #11

Updated by Nicolas CHARLES almost 2 years ago

  • Related to Bug #14742: System technique don't support PostgreSQL from other source than the distribution added
Actions

Also available in: Atom PDF