Re: initdb fails with error

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

On Thu, Sep 16, 2021, 7:47 AM Nikhil Shetty <nikhil.dba04@xxxxxxxxx> 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

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux