Project

General

Profile

Actions
Copy link

Bug #9182

closed

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

Bug #9182: Multiple errors "The postgresql process was not running and has been restarted"

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

Status:
Released
Priority:
1 (highest)
Assignee:
Alexis Mousset
Category:
System techniques
Target version:
3.1.17
Pull Request:
https://github.com/Normation/rudder-t...
Severity:
UX impact:
User visibility:
Effort required:
Priority:
0
Name check:
Fix check:
Regression:

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 1 (0 open — 1 closed)

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

Updated by Alexis Mousset almost 10 years ago Actions
Copy link
 #1

  • 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 almost 10 years ago Actions
Copy link
 #2

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É almost 10 years ago Actions
Copy link
 #3

  • Target version changed from 3.1.15 to 3.1.16

Updated by Vincent MEMBRÉ almost 10 years ago Actions
Copy link
 #4

  • Target version changed from 3.1.16 to 3.1.17

Updated by Nicolas CHARLES almost 10 years ago Actions
Copy link
 #5

  • Translation missing: en.field_tag_list set to Sponsored
  • Priority changed from N/A to 1 (highest)

Updated by Nicolas CHARLES almost 10 years ago Actions
Copy link
 #6

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

Updated by Nicolas CHARLES almost 10 years ago Actions
Copy link
 #7

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

postgres: 9.6/main: writer process

Updated by Nicolas CHARLES almost 10 years ago Actions
Copy link
 #8

  • 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 almost 10 years ago Actions
Copy link
 #9

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

Updated by Vincent MEMBRÉ over 9 years ago Actions
Copy link
 #10

  • 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.

Updated by Nicolas CHARLES over 7 years ago Actions
Copy link
 #11

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

Updated by Alexis Mousset over 4 years ago Actions
Copy link
 #12

  • Priority set to 0
Actions
Copy link

Also available in: PDF Atom