Re: OS X 10.11.3, psql, bus error 10, 9.5.1

Hello again,

no such luck (no easy fix). I turned SIP off and rebuilt PG 9.5.1, copied libpq.5.8.dylib to /usr/lib, bent the two sym
linksto the new library but I'm still getting "Bus error: 10". You owe somebody a nickel, Tom ;). 

Larsaf:postgresql-9.5.1 root# cp src/interfaces/libpq/libpq.5.8.dylib /usr/lib
Larsaf:postgresql-9.5.1 root# cd /usr/lib
Larsaf:lib root# ls -l libpq*
-rwxr-xr-x  1 root  wheel   147456 Dec  3 01:34 libpq.5.6.dylib
-rwxr-xr-x  1 root  wheel  2295376 Mar 12 16:22 libpq.5.8.dylib
lrwxr-xr-x  1 root  wheel       15 Dec 31 12:56 libpq.5.dylib -> libpq.5.6.dylib
lrwxr-xr-x  1 root  wheel       15 Dec 31 12:56 libpq.dylib -> libpq.5.6.dylib
Larsaf:lib root# rm libpq.5.dylib
Larsaf:lib root# rm libpq.dylib
Larsaf:lib root# ln -s libpq.5.8.dylib libpq.5.dylib
Larsaf:lib root# ln -s libpq.5.8.dylib libpq.dylib
Larsaf:lib root# ls -l libpq*
-rwxr-xr-x  1 root  wheel   147456 Dec  3 01:34 libpq.5.6.dylib
-rwxr-xr-x  1 root  wheel  2295376 Mar 12 16:22 libpq.5.8.dylib
lrwxr-xr-x  1 root  wheel       15 Mar 12 16:23 libpq.5.dylib -> libpq.5.8.dylib
lrwxr-xr-x  1 root  wheel       15 Mar 12 16:23 libpq.dylib -> libpq.5.8.dylib
Larsaf:lib root# cd -
/Users/chris/Develop/source/postgresql-9.5.1
Larsaf:postgresql-9.5.1 root# src/bin/psql/psql
Bus error: 10

My configure script looks like this (and this works for building PG 9.4.4 on the same machine with SIP enabled):

export CC=cc
export CPP="cc -E"
export CXX=c++
export CXXFLAGS='-O3 -fno-common -arch x86_64'
export CFLAGS='-O3 -fno-common -arch x86_64 -I/usr/local/include'
export LDFLAGS='-O3 -fno-common -arch x86_64 -L/usr/local/lib'

./configure  \
  --prefix=/usr/local              \
  --enable-integer-datetimes \
  --enable-thread-safety        \
  --with-perl             \
  --with-python           \
  --with-gssapi           \
  --with-openssl             \
  --with-pam              \
  --with-zlib             \
  --with-libxml         \
  --with-libxslt        \
  --with-uuid=e2fs      \
  --with-tcl              \
  --with-tclconfig=/usr/local/Cellar/tcl-tk/8.6.4/lib/ \
  --with-perl \
  --with-python


> On Mar 11, 2016, at 22:40, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Chris Ruprecht <chris@cdrbill.com> writes:
>> today, I built PG 9.5.1 on my Mac. Everything went fine with the build, as usual but after installing everything,
psqldid nothing but give a 'bus error: 10'. Loading it into gdb gave me more details:  
>
>> Program received signal SIGBUS, Bus error.
>> 0x000000010001be6c in refresh_utf8format ()
>
> I'd bet a nickel this is caused by El Capitan's "System Integrity
> Protection" deciding that your psql does not need the libpq version
> it asked for and should get linked to /usr/lib/libpq.dylib instead
> (which of course is several PG versions behind ...)
>
> SIP is potentially a good idea, but until they get the policies it
> enforces worked out, it's about where SELinux was ten years ago: the
> first thing you do is turn it off, if you want to get any work done.
> Right now it's an absolute disaster for anyone doing software
> development work.
>
> Here's what I have bookmarked about turning it off:
> http://www.howtogeek.com/230424/how-to-disable-system-integrity-protection-on-a-mac-and-why-you-shouldnt/
>
> If turning off SIP doesn't fix things, we'll need to look closer.
>
>             regards, tom lane