pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
To: Mohammed Shahid Nawaz <mohammedshahid.r@gmail.com>
Cc: Shreeyansh Dba <shreeyansh2014@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: "postgres" is needed by initdb but was not found
Date: Mon, 9 Jul 2018 00:11:57 +1200
Message-ID: <3ed50135-9bc2-6096-09bc-97a40225c433@catalyst.net.nz> (raw)
In-Reply-To: <CAG5wiRxgHJPBV31de9aN8EdZSjs_NP3LbzNJGvq3nsvVg0c8KA@mail.gmail.com>
References: <926506.81971.qm@web65907.mail.ac4.yahoo.com>
	<4DAC6CEA020000250003C984@gw.wicourts.gov>
	<1530899160672-0.post@n3.nabble.com>
	<CAGDYbUMv7B6nezNrmqshMxwj5oVR+W=dtOF2CU5aU3d-RvXBjg@mail.gmail.com>
	<CAG5wiRw1W+hLRD6re4V52JZn-CF2ZiXT1WMRvsYewvh0e78hVg@mail.gmail.com>
	<22ccdf09-a7c7-7560-67ac-1d8f07a2ace8@catalyst.net.nz>
	<CAG5wiRxgHJPBV31de9aN8EdZSjs_NP3LbzNJGvq3nsvVg0c8KA@mail.gmail.com>

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
>     >
>     >
>





view thread (14+ messages)  latest in thread

Message-ID: <3ed50135-9bc2-6096-09bc-97a40225c433@catalyst.net.nz>
Permalink:  ../3ed50135-9bc2-6096-09bc-97a40225c433@catalyst.net.nz/
Also on:    postgresql.org/message-id/3ed50135-9bc2-6096-09bc-97a40225c433@catalyst.net.nz

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: mark.kirkwood@catalyst.net.nz, mohammedshahid.r@gmail.com, shreeyansh2014@gmail.com
  Subject: Re: "postgres" is needed by initdb but was not found
  In-Reply-To: <3ed50135-9bc2-6096-09bc-97a40225c433@catalyst.net.nz>
  References: <926506.81971.qm@web65907.mail.ac4.yahoo.com> <4DAC6CEA020000250003C984@gw.wicourts.gov> <1530899160672-0.post@n3.nabble.com> <CAGDYbUMv7B6nezNrmqshMxwj5oVR+W=dtOF2CU5aU3d-RvXBjg@mail.gmail.com> <CAG5wiRw1W+hLRD6re4V52JZn-CF2ZiXT1WMRvsYewvh0e78hVg@mail.gmail.com> <22ccdf09-a7c7-7560-67ac-1d8f07a2ace8@catalyst.net.nz> <CAG5wiRxgHJPBV31de9aN8EdZSjs_NP3LbzNJGvq3nsvVg0c8KA@mail.gmail.com> <3ed50135-9bc2-6096-09bc-97a40225c433@catalyst.net.nz>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox