From: | Jayson Hreczuck <jayson(dot)hreczuck(at)studentuniverse(dot)com> |
---|---|
To: | Nikhil Shetty <nikhil(dot)dba04(at)gmail(dot)com> |
Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: initdb fails with error |
Date: | 2021-09-16 11:50:53 |
Message-ID: | CAHg7=h4N=pEJToxb9XuQ9nBM_Sq=D4DqXV+E-Kwiw+8=rA7i0g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2021-09-16 13:14:02 | Re: initdb fails with error |
Previous Message | Nikhil Shetty | 2021-09-16 11:47:18 | initdb fails with error |