Re: "postgres" is needed by initdb but was not found - Mailing list pgsql-admin

From Shreeyansh Dba
Subject Re: "postgres" is needed by initdb but was not found
Date
Msg-id CAGDYbUMv7B6nezNrmqshMxwj5oVR+W=dtOF2CU5aU3d-RvXBjg@mail.gmail.com
Whole thread Raw
In response to Re: "postgres" is needed by initdb but was not found  (mohammed shahid <mohammedshahid.r@gmail.com>)
Responses Re: "postgres" is needed by initdb but was not found  (Mohammed Shahid Nawaz <mohammedshahid.r@gmail.com>)
List pgsql-admin
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 <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


pgsql-admin by date:

Previous
From: "Jernigan, Kevin"
Date:
Subject: Re: Partitioning tables
Next
From: Mohammed Shahid Nawaz
Date:
Subject: Re: "postgres" is needed by initdb but was not found