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
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 |