Re: "postgres" is needed by initdb but was not found - Mailing list pgsql-admin

Hmm - Postgres will refuse to run as the root user (security reasons).


On 08/07/18 23:21, Mohammed Shahid Nawaz wrote:
> Hi Mark,
> I have built the source code on 64bit and trying to run on 64bit system.
>
> The same build  works on 64bit  non-root user login of the same system.
>
>
> Thanks,
> Mohammed Shahid Nawaz
>
> On Sun 8 Jul, 2018, 3:38 PM Mark Kirkwood, 
> <mark.kirkwood@catalyst.net.nz <mailto:mark.kirkwood@catalyst.net.nz>> 
> wrote:
>
>     The message 'invalid binary' suggests the wrong architecture binaries
>     are installed (e.g 32 bit on 64 bit machine or vice versa). if you
>     were
>     missing the initdb binary your would get a different message (e.g):
>
>     The The program "initdb" is needed by pg_ctl but was not found in the
>     same directory as "/usr/local/bin/pg_ctl".
>
>     regards
>     Mark
>
>     On 07/07/18 17:37, Mohammed Shahid Nawaz wrote:
>     > 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@gmail.com <mailto:shreeyansh2014@gmail.com>
>     > <mailto:shreeyansh2014@gmail.com
>     <mailto:shreeyansh2014@gmail.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.r@gmail.com
>     <mailto:mohammedshahid.r@gmail.com>
>     <mailto:mohammedshahid.r@gmail.com
>     <mailto:mohammedshahid.r@gmail.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
>     >
>     >
>