Re: "postgres" is needed by initdb but was not found

Hi Shreeyansh,
Thank you for the feedback.
The problem continues to exist even while using initdb command.

I had been using pg_ctl to initiate a db in my earlier version 9.6.3 as
well.

The command goes as follows, and its working on non-root user login for the
same build version 10.4.

su - postgres -c '/root/pgsql10x/bin/pg_ctl -D /root/pgsql10x/data/ initdb'

Thanks,
Mohammed Shahid Nawaz

On Sat 7 Jul, 2018, 10:42 AM Shreeyansh Dba, <shreeyansh2014(at)gmail(dot)com>
wrote:

> Hi Mohammed,
>
> As I suspect that you are trying to create a cluster but pg_ctl is a not a
> valid option to create a cluster.
>
> You can use initdb option for creating a cluster...
>
> Hope this helps.
>
>
> <http://www.shreeyansh.com>
>
> On Fri, Jul 6, 2018 at 11:16 PM, mohammed shahid <
> mohammedshahid(dot)r(at)gmail(dot)com> wrote:
>
>> Hi Kevin,
>>
>> I am new to this forum, but even i am facing this issue as reported where
>> i
>> get the below error.
>>
>> sudo -u shahid ./pg_ctl -D /root/pgsql10x/data/ initdb
>> invalid binary "/root/pgsql10x/bin/pg_ctl"
>> invalid binary "/root/pgsql10x/bin/pg_ctl"
>> invalid binary "/root/pgsql10x/bin/pg_ctl"
>> The program "initdb" is needed by pg_ctl but was not found in the
>> same directory as "pg_ctl".
>> Check your installation.
>>
>> FYI ,
>> I am trying to run this from root.
>> As reported by H S, even i have built from the source. I am trying version
>> 10. on CentOS7.
>> I downloaded direct from postgres site.
>> I am not facing this problem when i run as non-root user.
>>
>> I have all the files in the bin directory, as shared below,
>>
>> -rwxrwxrwx. 1 shahid shahid 7604946 Jul 6 17:19 postgres
>> lrwxrwxrwx. 1 shahid shahid 8 Jul 6 17:19 postmaster -> postgres
>> -rwxr-xr-x. 1 shahid shahid 908965 Jul 6 17:19 ecpg
>> -rwxr-xr-x. 1 shahid shahid 128690 Jul 6 17:19 initdb
>> -rwxr-xr-x. 1 shahid shahid 30548 Jul 6 17:19 pg_archivecleanup
>> -rwxr-xr-x. 1 shahid shahid 112608 Jul 6 17:19 pg_basebackup
>> -rwxr-xr-x. 1 shahid shahid 71241 Jul 6 17:19 pg_receivewal
>> -rwxr-xr-x. 1 shahid shahid 72771 Jul 6 17:19 pg_recvlogical
>> -rwxr-xr-x. 1 shahid shahid 30009 Jul 6 17:19 pg_config
>> -rwxr-xr-x. 1 shahid shahid 39920 Jul 6 17:19 pg_controldata
>> -rwxr-xr-x. 1 shahid shahid 58438 Jul 6 17:19 pg_ctl
>> -rwxr-xr-x. 1 shahid shahid 400623 Jul 6 17:19 pg_dump
>> -rwxr-xr-x. 1 shahid shahid 164991 Jul 6 17:19 pg_restore
>> -rwxr-xr-x. 1 shahid shahid 97686 Jul 6 17:19 pg_dumpall
>> -rwxr-xr-x. 1 shahid shahid 49138 Jul 6 17:19 pg_resetwal
>> -rwxr-xr-x. 1 shahid shahid 88205 Jul 6 17:19 pg_rewind
>> -rwxr-xr-x. 1 shahid shahid 31798 Jul 6 17:19 pg_test_fsync
>> -rwxr-xr-x. 1 shahid shahid 26337 Jul 6 17:19 pg_test_timing
>> -rwxr-xr-x. 1 shahid shahid 130515 Jul 6 17:19 pg_upgrade
>> -rwxr-xr-x. 1 shahid shahid 86270 Jul 6 17:19 pg_waldump
>> -rwxr-xr-x. 1 shahid shahid 141273 Jul 6 17:19 pgbench
>> -rwxr-xr-x. 1 shahid shahid 454216 Jul 6 17:19 psql
>> -rwxr-xr-x. 1 shahid shahid 60635 Jul 6 17:19 createdb
>> -rwxr-xr-x. 1 shahid shahid 56335 Jul 6 17:19 dropdb
>> -rwxr-xr-x. 1 shahid shahid 64416 Jul 6 17:19 createuser
>> -rwxr-xr-x. 1 shahid shahid 56305 Jul 6 17:19 dropuser
>> -rwxr-xr-x. 1 shahid shahid 61135 Jul 6 17:19 clusterdb
>> -rwxr-xr-x. 1 shahid shahid 68735 Jul 6 17:19 vacuumdb
>> -rwxr-xr-x. 1 shahid shahid 64047 Jul 6 17:19 reindexdb
>> -rwxr-xr-x. 1 shahid shahid 59104 Jul 6 17:19 pg_isready
>>
>> Thanks
>> Shahid
>>
>>
>>
>>
>>
>> --
>> Sent from:
>> http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html
>>
>>
>