Обсуждение: initdb fails with error

Поиск
Список
Период
Сортировка

initdb fails with error

От
Nikhil Shetty
Дата:
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

Re: initdb fails with error

От
Jayson Hreczuck
Дата:
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@gmail.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

Re: initdb fails with error

От
Tom Lane
Дата:
Nikhil Shetty <nikhil.dba04@gmail.com> writes:
> running bootstrap script ... 2021-09-16 11:42:47.944 GMT [24522] FATAL:
>  invalid value for parameter "port": ""

Perhaps you have an incorrect environment setting for PGPORT ?
I can duplicate that if I run initdb after
export PGPORT=""

            regards, tom lane

Re: initdb fails with error

От
Mladen Gogala
Дата:
On 9/16/21 07:47, Nikhil Shetty wrote:

> Hi Team,
>
> I find strange behaviour today when initializing the postgres cluster.
>
> Below is the ERROR :
>
> 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


Do you have the local firewall running?

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

Re: initdb fails with error

От
Holger Jakobs
Дата:
Firewall may prevent a connection, but not starting is the server.

The message clearly states that the setting of the port is wrong.

Am 16. September 2021 16:43:04 MESZ schrieb Mladen Gogala <gogala.mladen@gmail.com>:
>On 9/16/21 07:47, Nikhil Shetty wrote:
>
>> Hi Team,
>>
>> I find strange behaviour today when initializing the postgres cluster.
>>
>> Below is the ERROR :
>>
>> 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
>
>
>Do you have the local firewall running?
>

--
Holger Jakobs, Bergisch Gladbach
+49 178 9759012
- sent from mobile, therefore short -

Re: initdb fails with error

От
Nikhil Shetty
Дата:
Hi Jayson,

Port is correct. I don't see any issue with the parameter in postgresql.conf. After a couple of tries it worked but not sure why

Thanks,
Nikhil

On Thu, Sep 16, 2021 at 5:21 PM Jayson Hreczuck <jayson.hreczuck@studentuniverse.com> wrote:
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@gmail.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

Re: initdb fails with error

От
Mladen Gogala
Дата:
On 9/17/21 04:57, Nikhil Shetty wrote:
> Hi Jayson,
>
> Port is correct. I don't see any issue with the parameter in 
> postgresql.conf. After a couple of tries it worked but not sure why
>
> Thanks,
> Nikhil


I would try something like "strace -e trace=file -f -o /tmp/initdb.out 
initdb <args>".  That should reveal the nature of the problem.

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com