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

Hi Mark,
Hence we run using sudo command or with 'su' from the root.
I have been running this command through from admin for version 9.6.3., it
works.

Thanks
Mohammed Shahid Nawaz

On Sun 8 Jul, 2018, 5:42 PM Mark Kirkwood, <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>
wrote:

> 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(dot)kirkwood(at)catalyst(dot)net(dot)nz <mailto:mark(dot)kirkwood(at)catalyst(dot)net(dot)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(at)gmail(dot)com <mailto:shreeyansh2014(at)gmail(dot)com>
> > > <mailto:shreeyansh2014(at)gmail(dot)com
> > <mailto: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
> > <mailto:mohammedshahid(dot)r(at)gmail(dot)com>
> > <mailto:mohammedshahid(dot)r(at)gmail(dot)com
> > <mailto: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
> > >
> > >
> >
>
>