Re: initdb fails with error

Check your postgresql.conf file and confirm there is an appropriate port
listed.

On Thu, Sep 16, 2021, 7:47 AM Nikhil Shetty <nikhil(dot)dba04(at)gmail(dot)com> wrote:

> Hi Team,
>
> I find strange behaviour today when initializing the postgres cluster.
>
> Below is the ERROR :
>
>
> $$>/usr/pgsql-11/bin/initdb -D /data/postgres/pg11/test -d
> Running in debug mode.
> The files belonging to this database system will be owned by user
> "postgres".
> This user must also own the server process.
>
> VERSION=11.7
> PGDATA=/data/postgres/pg11/test
> share_path=/usr/pgsql-11/share
> PGPATH=/usr/pgsql-11/bin
> POSTGRES_SUPERUSERNAME=postgres
> POSTGRES_BKI=/usr/pgsql-11/share/postgres.bki
> POSTGRES_DESCR=/usr/pgsql-11/share/postgres.description
> POSTGRES_SHDESCR=/usr/pgsql-11/share/postgres.shdescription
> POSTGRESQL_CONF_SAMPLE=/usr/pgsql-11/share/postgresql.conf.sample
> PG_HBA_SAMPLE=/usr/pgsql-11/share/pg_hba.conf.sample
> PG_IDENT_SAMPLE=/usr/pgsql-11/share/pg_ident.conf.sample
> The database cluster will be initialized with locale "en_US.UTF-8".
> The default database encoding has accordingly been set to "UTF8".
> The default text search configuration will be set to "english".
>
> Data page checksums are disabled.
>
> creating directory /data/postgres/pg11/test ... ok
> creating subdirectories ... ok
> selecting default max_connections ... 20
> selecting default shared_buffers ... 400kB
> selecting default timezone ... America/Los_Angeles
> selecting dynamic shared memory implementation ... posix
> creating configuration files ... ok
> running bootstrap script ... 2021-09-16 11:42:47.944 GMT [24522] FATAL:
> invalid value for parameter "port": ""
> child process exited with exit code 1
> initdb: removing data directory "/data/postgres/pg11/test"
>
> Any reason why this would be happening?
>
> Thanks,
> Nikhil
>