BUG #15736: running bootstrap script ... FATAL: invalid value for parameter "port": ""

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: herwig(dot)goemans(at)gmail(dot)com
Subject: BUG #15736: running bootstrap script ... FATAL: invalid value for parameter "port": ""
Date: 2019-04-04 15:08:34
Message-ID: 15736-8dcdff2dd9e85e39@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 15736
Logged by: Herwig Goemans
Email address: herwig(dot)goemans(at)gmail(dot)com
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

Browse pgsql-bugs by date

  From Date Subject
Next Message bricklen 2019-04-04 17:28:26 Re: BUG #15735: postgis extension missing
Previous Message Rossiter, Russell D. 2019-04-04 14:36:33 Bug trying to view table