[MacPorts] #49095: postgresql94 El Capitan initdb using default instructions fails without any failure message.

[MacPorts]

#49095: postgresql94 El Capitan initdb using default instructions fails without any
failure message.
---------------------+--------------------------------
 Reporter:  neilt@…  |      Owner:  macports-tickets@…
     Type:  defect   |     Status:  new
 Priority:  High     |  Milestone:
Component:  ports    |    Version:  2.3.4
 Keywords:           |       Port:  postgresql94
---------------------+--------------------------------
 Removed MacPorts and Xcode, upgraded to El Capitan, install Xcode 7.0.1,
 install new MacPorts 2.3.4.  Then start installing ports manually.
 Installed postgresql94 then postgresql94-server.  Created the default dir
 using the commands from the install script.

 Then I went to look at the init'd database and it was not present.
 {{{
 MBP:postgresql94 nt$ sudo mkdir -p
 /opt/local/var/db/postgresql94/defaultdb
 MBP:postgresql94 nt$ sudo chown postgres:postgres
 /opt/local/var/db/postgresql94/defaultdb
 MBP:postgresql94 nt$ sudo su postgres -c
 '/opt/local/lib/postgresql94/bin/initdb -D
 /opt/local/var/db/postgresql94/defaultdb'
 MBP:postgresql94 nt$ cd /opt/local/var/db/postgresql94/defaultdb
 MBP:defaultdb nt$ pwd
 /opt/local/var/db/postgresql94/defaultdb
 MBP:defaultdb nt$ ls -lah
 total 0
 drwxr-xr-x  2 postgres  postgres    68B Oct  4 12:47 .
 drwxr-xr-x  3 root      admin      102B Oct  4 12:47 ..
 MBP:defaultdb nt$ cd ..
 MBP:postgresql94 nt$ pwd
 /opt/local/var/db/postgresql94
 MBP:postgresql94 nt$ ls -lah
 total 0
 drwxr-xr-x  3 root      admin      102B Oct  4 12:47 .
 drwxr-xr-x  3 root      admin      102B Oct  4 12:47 ..
 drwxr-xr-x  2 postgres  postgres    68B Oct  4 12:47 defaultdb
 }}}
 The above is the exact output from the commands.  The port install did not
 show any abnormal results at all.  I did the 'csrutil disable' thinking
 that might be part of the problem with the new security, but it did not
 make a difference.  I have removed postgresql and installed it multiple
 times.  The binaries are present '/opt/local/lib/postgresql94/bin'

 If I try to initdb a database in my user account it works fine.
 {{{
 MBP:~ nt$ mkdir postgresql_test
 MBP:~ nt$ cd postgresql_test
 MBP:postgresql_test nt$ /opt/local/lib/postgresql94/bin/initdb -D .
 The files belonging to this database system will be owned by user "nt".
 This user must also own the server process.

 The database cluster will be initialized with locale "C".
 The default database encoding has accordingly been set to "SQL_ASCII".
 The default text search configuration will be set to "english".

 Data page checksums are disabled.

 fixing permissions on existing directory . ... ok
 creating subdirectories ... ok
 selecting default max_connections ... 100
 selecting default shared_buffers ... 128MB
 selecting dynamic shared memory implementation ... posix
 creating configuration files ... ok
 creating template1 database in ./base/1 ... ok
 initializing pg_authid ... ok
 initializing dependencies ... ok
 creating system views ... ok
 loading system objects' descriptions ... ok
 creating collations ... ok
 creating conversions ... ok
 creating dictionaries ... ok
 setting privileges on built-in objects ... ok
 creating information schema ... ok
 loading PL/pgSQL server-side language ... ok
 vacuuming database template1 ... ok
 copying template1 to template0 ... ok
 copying template1 to postgres ... ok
 syncing data to disk ... ok

 WARNING: enabling "trust" authentication for local connections
 You can change this by editing pg_hba.conf or using the option -A, or
 --auth-local and --auth-host, the next time you run initdb.

 Success. You can now start the database server using:

     /opt/local/lib/postgresql94/bin/postgres -D .
 or
     /opt/local/lib/postgresql94/bin/pg_ctl -D . -l logfile start

 MBP:postgresql_test nt$
 }}}

 I don't have any idea how to troubleshoot this when no error messages are
 printed.

-- 
Ticket URL: <https://trac.macports.org/ticket/49095>
MacPorts <https://www.macports.org/>
Ports system for OS X