Project

General

Profile

Actions

User story #9208

closed

Require postgres 9.4

Added by François ARMAND about 8 years ago. Updated about 6 years ago.

Status:
Rejected
Priority:
N/A
Assignee:
-
Category:
Architecture - Dependencies
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 open1 closed)

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

Updated by François ARMAND about 8 years ago

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

Updated by François ARMAND about 8 years ago

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

Updated by François ARMAND about 8 years ago

  • Description updated (diff)
Actions #4

Updated by Benoît PECCATTE about 8 years ago

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

Updated by Vincent MEMBRÉ about 8 years ago

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

Updated by Vincent MEMBRÉ about 8 years ago

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

Updated by Vincent MEMBRÉ about 8 years ago

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

Updated by Benoît PECCATTE about 8 years ago

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

Actions #9

Updated by François ARMAND about 8 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 #10

Updated by François ARMAND about 8 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 #11

Updated by François ARMAND almost 8 years ago

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

Updated by Alexis Mousset almost 8 years ago

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

Updated by Benoît PECCATTE about 6 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

Also available in: Atom PDF