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 about 1 year ago. Updated about 1 year 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

Also available in: Atom PDF