Project

General

Profile

Actions
Copy link

User story #9208

closed

Require postgres 9.4

Added by François ARMAND over 7 years ago. Updated over 5 years ago.

Status:
Rejected
Priority:
N/A
Assignee:
-
Category:
Architecture - Dependencies
Target version:
Ideas (not version specific)
Pull Request:
UX impact:
Suggestion strength:
User visibility:
Effort required:
Name check:
Fix check:
Regression:

Description

For now, we are only requiring postgresql v8.4.

Version 9.x provide enormous perfomance gain, especially regarding the way we manage agent reports or xml.

Currently, these versions are available by default:

- Debian 7: postgres 9.1
- Debien 7 backports / Debian 8: 9.4

- Ubuntu 14.04: postgres 9.3
- Ubuntu 16.04: postgres 9.5

- Sles 11sp4 / 12 / 12sp1: postgres 9.4

- centos 6: postgres 8.4
- centos 7: postgres 9.2

So we could ask for Postgres 9.2 with migration path from any currently supported server version.

The requirement may be at first only one the documentation, worded in the form "Rudder 4.0 is tested for Postgre 9.2 and higer. It may still works for now with version 8.4 to 9.1, but not garanties are made that this will hold in the future".

Subtasks 1 (0 open — 1 closed)

User story #9229: Document Postgresql 9.2 recommandationReleasedAlexis MoussetActions
Actions
Copy link
 #1

Updated by François ARMAND over 7 years ago

  • Subject changed from Require postgres 9;x in Rudder 4.0 to Require postgres 9.x in Rudder 4.0
Actions
Copy link
 #2

Updated by François ARMAND over 7 years ago

  • Subject changed from Require postgres 9.x in Rudder 4.0 to Require postgres 9.2 in Rudder 4.0
Actions
Copy link
 #3

Updated by François ARMAND over 7 years ago

  • Description updated (diff)
Actions
Copy link
 #4

Updated by Benoît PECCATTE over 7 years ago

  • Target version changed from 4.0.0~rc2 to 4.0.0~rc3
Actions
Copy link
 #5

Updated by Vincent MEMBRÉ over 7 years ago

  • Target version changed from 4.0.0~rc3 to 4.0.0~rc4
Actions
Copy link
 #6

Updated by Vincent MEMBRÉ over 7 years ago

  • Target version changed from 4.0.0~rc4 to 4.0.0~rc5
Actions
Copy link
 #7

Updated by Vincent MEMBRÉ over 7 years ago

  • Target version changed from 4.0.0~rc5 to 4.0.0
Actions
Copy link
 #8

Updated by Benoît PECCATTE over 7 years ago

Nicolas, what do you think of requiring postgresql 9.2 in the packaging ?

Actions
Copy link
 #9

Updated by François ARMAND over 7 years ago

In fact, we won't require 9.2. We should ask for 9.4 to have efficient JSON queries, but that is more a documentation thing, so in #9229.

Actions
Copy link
 #10

Updated by François ARMAND over 7 years ago

  • Subject changed from Require postgres 9.2 in Rudder 4.0 to Require postgres 9.2 in Rudder 4.2
  • Target version changed from 4.0.0 to Ideas (not version specific)
Actions
Copy link
 #11

Updated by François ARMAND about 7 years ago

  • Subject changed from Require postgres 9.2 in Rudder 4.2 to Require postgres 9.2 in Rudder 4.1
Actions
Copy link
 #12

Updated by Alexis Mousset about 7 years ago

  • Subject changed from Require postgres 9.2 in Rudder 4.1 to Require postgres 9.4
Actions
Copy link
 #13

Updated by Benoît PECCATTE over 5 years ago

  • Status changed from New to Rejected

We now depend on postgresql 9.2 since we must support centos7 (for a long time).

Actions
Copy link

Also available in: Atom PDF