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

From: Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com>
To: mohammed shahid <mohammedshahid(dot)r(at)gmail(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: "postgres" is needed by initdb but was not found
Date: 2018-07-07 05:12:46
Message-ID: CAGDYbUMv7B6nezNrmqshMxwj5oVR+W=dtOF2CU5aU3d-RvXBjg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-novice

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Mohammed Shahid Nawaz 2018-07-07 05:37:11 Re: "postgres" is needed by initdb but was not found
Previous Message Jernigan, Kevin 2018-07-06 21:39:50 Re: Partitioning tables

Browse pgsql-novice by date

  From Date Subject
Next Message Mohammed Shahid Nawaz 2018-07-07 05:37:11 Re: "postgres" is needed by initdb but was not found
Previous Message mohammed shahid 2018-07-06 17:46:00 Re: "postgres" is needed by initdb but was not found