Re: Psql and OS X

Mitch Vincent sez:
} I'm seeing lots of funny things happen with psql and MacOS X. I had the
} readline libs installed before I compiled PG (which compiled clean as a
} whistle BTW) -- but still I have no command buffer and about half the time
} selects, / commands and such will return crazy formatted results (well, the
} results are not formatted I should say).. I'm using BASH as the shell and
} the terminal program that comes standard with OS X... I notice that there is
} no .psql_history file being written..

Hm. Strange. I'm using 7.2.1 on OS X with no difficulty.

} I reinstalled a binary distribution that claimed to have compiled support
} for readline in, but I'm not positive.. Still, the same thing happened when
} I compiled 7.2.1 on this box myself...

Where are your readline libraries? And include files? I have mine in
/usr/local (NOTE: this is because I fooled Fink with a symlink from /sw to
/usr/local, but it turns out that the psql I compiled is finding it in /sw
anyway).

} Is there a way to see now if psql found the readline libs?

The equivalent of ldd on OS X is otool -L; man otool for details. The
results I get are:

% otool -L `which psql`
/space/postgresql/bin/psql:
        /usr/lib/libssl.0.9.dylib (compatibility version 0.9.0, current version 0.9.6)
        /usr/lib/libcrypto.0.9.dylib (compatibility version 0.9.0, current version 0.9.6)
        /usr/lib/libz.1.1.3.dylib (compatibility version 1.0.0, current version 1.1.3)
        /sw/lib/libdl.0.dylib (compatibility version 0.0.0, current version 0.0.0)
        /usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version 55.0.0)
        /sw/lib/libreadline.4.2.dylib (compatibility version 4.2.0, current version 4.2.0)

} Any other ideas?
} Thanks!!
} -Mitch
--Greg