Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fc8YB-00062L-Gf for pgsql-admin@arkaria.postgresql.org; Sun, 08 Jul 2018 12:12:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fc8Y6-0003nx-Th for pgsql-admin@arkaria.postgresql.org; Sun, 08 Jul 2018 12:12:18 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fc8Y6-0003np-MK for pgsql-admin@lists.postgresql.org; Sun, 08 Jul 2018 12:12:18 +0000 Received: from cat-porwal-prod-mail1.catalyst.net.nz ([2404:130:4080::4]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fc8Xy-0004hR-IL for pgsql-admin@postgresql.org; Sun, 08 Jul 2018 12:12:15 +0000 Authentication-Results: auth=pass smtp.auth=mark.kirkwood@catalyst.net.nz smtp.mailfrom=mark.kirkwood@catalyst.net.nz Received: from [IPv6:2406:e001:cf9:1:4949:d93a:590:5a13] (unknown [IPv6:2406:e001:cf9:1:4949:d93a:590:5a13]) (Authenticated sender: mark.kirkwood@catalyst.net.nz) by cat-porwal-prod-mail1.catalyst.net.nz (Postfix) with ESMTPSA id B16AA806A4; Mon, 9 Jul 2018 00:11:58 +1200 (NZST) Subject: Re: "postgres" is needed by initdb but was not found To: Mohammed Shahid Nawaz Cc: Shreeyansh Dba , pgsql-admin References: <926506.81971.qm@web65907.mail.ac4.yahoo.com> <4DAC6CEA020000250003C984@gw.wicourts.gov> <1530899160672-0.post@n3.nabble.com> <22ccdf09-a7c7-7560-67ac-1d8f07a2ace8@catalyst.net.nz> From: Mark Kirkwood Message-ID: <3ed50135-9bc2-6096-09bc-97a40225c433@catalyst.net.nz> Date: Mon, 9 Jul 2018 00:11:57 +1200 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.8.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 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, > > > 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, > > > >> 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. > > > > > >      > > > >     On Fri, Jul 6, 2018 at 11:16 PM, mohammed shahid > >      > >> > >     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 > > > > >