From: | Mohammed Shahid Nawaz <mohammedshahid(dot)r(at)gmail(dot)com> |
---|---|
To: | Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz> |
Cc: | Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: "postgres" is needed by initdb but was not found |
Date: | 2018-07-08 11:21:17 |
Message-ID: | CAG5wiRxgHJPBV31de9aN8EdZSjs_NP3LbzNJGvq3nsvVg0c8KA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-novice |
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>
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>> 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>>
> > 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
> >
> >
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Kirkwood | 2018-07-08 12:11:57 | Re: "postgres" is needed by initdb but was not found |
Previous Message | Mark Kirkwood | 2018-07-08 10:08:54 | Re: "postgres" is needed by initdb but was not found |
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Kirkwood | 2018-07-08 12:11:57 | Re: "postgres" is needed by initdb but was not found |
Previous Message | Mark Kirkwood | 2018-07-08 10:08:54 | Re: "postgres" is needed by initdb but was not found |