Project

General

Profile

Actions
Copy link

Bug #23395

closed

Bug #23388: Server install fails with postgresql encoding error

Error in create database syntaxe: template AFTER owner

Added by François ARMAND 8 months ago. Updated 8 months ago.

Status:
Released
Priority:
N/A
Assignee:
Alexis Mousset
Category:
Architecture - Code maintenance
Target version:
7.2.11
Pull Request:
https://github.com/Normation/rudder-p...
Severity:
UX impact:
User visibility:
Effort required:
Priority:
0
Name check:
To do
Fix check:
Checked
Regression:
No

Description

The syntax is not:

su postgres -c "psql -q -c \"CREATE DATABASE ${DB_NAME} TEMPLATE template0 WITH OWNER = ${DB_USER} ENCODING = UTF8\""

But

su postgres -c "psql -q -c \"CREATE DATABASE ${DB_NAME} WITH OWNER = ${DB_USER} TEMPLATE template0 ENCODING = UTF8\""

See: https://www.postgresql.org/docs/current/sql-createdatabase.html

Files

clipboard-202309061432-fx116.png (26.2 KB) clipboard-202309061432-fx116.png François ARMAND, 2023-09-06 14:32
Actions
Copy link
 #1

Updated by François ARMAND 8 months ago

  • Status changed from In progress to Pending technical review
  • Assignee changed from François ARMAND to Alexis Mousset
  • Pull Request set to https://github.com/Normation/rudder-packages/pull/2808
Actions
Copy link
 #2

Updated by Anonymous 8 months ago

  • Status changed from Pending technical review to Pending release
Actions
Copy link
 #3

Updated by Vincent MEMBRÉ 8 months ago

  • Fix check changed from To do to Checked
Actions
Copy link
 #4

Updated by Vincent MEMBRÉ 8 months ago

  • Status changed from Pending release to Released

This bug has been fixed in Rudder 7.2.11 and 7.3.7 which were released today.

Actions
Copy link

Also available in: Atom PDF