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@xxxxxxxxx> 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 <mohammedshahid.r@xxxxxxxxx> 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
