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