PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID15736
PG Version11.2
OSubuntu 18.04
Opened2019-04-04 15:08:34+00
Reported byHerwig Goemans
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      15736
Logged by:          Herwig Goemans
Email address:      (redacted)
PostgreSQL version: 11.2
Operating system:   ubuntu 18.04
Description:        

Hello support: thank you for helping me out with this problem/bug
I execute 

 pg_createcluster 11 awis -port=5432 -d /pgs002/awis/11/data -l
/pgs002/awis/11/data/pg_logging -e utf8 --locale nl_BE.utf8
which in turn calls: 
 /usr/lib/postgresql/11/bin/initdb --data-checksums
--pgdata=/pgs002/awis/11/data --auth-local peer --auth-host md5 --encoding
utf8 --locale nl_BE.utf8 -d -n
(I added the -d and -n option myself)

The I get following output:
Running in debug mode.
Running in no-clean mode.  Mistakes will not be cleaned up.
The files belonging to this database system will be owned by user
"postgres".
This user must also own the server process.

VERSION=11.2 (Ubuntu 11.2-1.pgdg18.04+1)
PGDATA=/pgs002/awis/11/data
share_path=/usr/share/postgresql/11
PGPATH=/usr/lib/postgresql/11/bin
POSTGRES_SUPERUSERNAME=postgres
POSTGRES_BKI=/usr/share/postgresql/11/postgres.bki
POSTGRES_DESCR=/usr/share/postgresql/11/postgres.description
POSTGRES_SHDESCR=/usr/share/postgresql/11/postgres.shdescription
POSTGRESQL_CONF_SAMPLE=/usr/share/postgresql/11/postgresql.conf.sample
PG_HBA_SAMPLE=/usr/share/postgresql/11/pg_hba.conf.sample
PG_IDENT_SAMPLE=/usr/share/postgresql/11/pg_ident.conf.sample
The database cluster will be initialized with locale "nl_BE.utf8".
The default text search configuration will be set to "dutch".

Data page checksums are enabled.

fixing permissions on existing directory /pgs002/awis/11/data ... ok
creating subdirectories ... ok
selecting default max_connections ... 20
selecting default shared_buffers ... 400kB
selecting dynamic shared memory implementation ... posix
creating configuration files ... ok
running bootstrap script ... 2019-04-04 13:32:06.847 GMT [20319] FATAL: 
invalid value for parameter "port": ""
child process exited with exit code 1
initdb: data directory "/pgs002/awis/11/data" not removed at user's
request


I modified the install:
/etc/postgresql-common$ diff createcluster.conf createcluster.conf.orig
6c6
< create_main_cluster = false
---
> #create_main_cluster = true
13c13
< data_directory = '/pgs002/%c/%v'
---
> #data_directory = '/var/lib/postgresql/%v/%c'
29c29
< cluster_name = '%c'
---
> cluster_name = '%v/%c'
32c32
< # stats_temp_directory = '/var/run/postgresql/%v-%c.pg_stat_tmp'
---
> stats_temp_directory = '/var/run/postgresql/%v-%c.pg_stat_tmp'
42d41
<
 
And
 cat createcluster.d/vmm_ubuntu.conf

initdb_options = '--data-checksums'
create_main_cluster = false
start_conf = 'auto'
cluster_name = '%c'
data_directory = '/pgs002/%c/%v'
listen_addresses = '*'
search_path = '"$user", public , informix'
log_directory = 'pg_log'

The server was restarted yesterday.
The OS is:
cat /etc/os-release
NAME="Ubuntu"
VERSION="18.04.2 LTS (Bionic Beaver)"
ID=ubuntu
ID_LIKE=debian
PRETTY_NAME="Ubuntu 18.04.2 LTS"
VERSION_ID="18.04"
Can you please help I cannot create a cluster any more. 

Kind regards,

Herwig

Messages

DateAuthorSubject
2019-04-04 15:08:34+00PG Bug reporting formBUG #15736: running bootstrap script ... FATAL: invalid value for parameter "port": ""