BUG #15736: running bootstrap script ... FATAL: invalid value for parameter "port": "" - Mailing list pgsql-bugs
From | PG Bug reporting form |
---|---|
Subject | BUG #15736: running bootstrap script ... FATAL: invalid value for parameter "port": "" |
Date | |
Msg-id | 15736-8dcdff2dd9e85e39@postgresql.org Whole thread Raw |
List | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 15736 Logged by: Herwig Goemans Email address: herwig.goemans@gmail.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
pgsql-bugs by date: