From: | Nikhil Shetty <nikhil(dot)dba04(at)gmail(dot)com> |
---|---|
To: | Jayson Hreczuck <jayson(dot)hreczuck(at)studentuniverse(dot)com> |
Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: initdb fails with error |
Date: | 2021-09-17 08:57:14 |
Message-ID: | CAFpL5Vz6rtJB6xUfPebdL4da-eJfPzxJ8dNc-1Hn_mMEUjb3qA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(dot)hreczuck(at)studentuniverse(dot)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(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 | Bossart, Nathan | 2021-09-17 16:31:44 | Re: Estimating HugePages Requirements? |
Previous Message | Michael Paquier | 2021-09-17 02:20:30 | Re: Estimating HugePages Requirements? |