Record of some of the computer tech I deal with so that it's documented at least somewhere.

Monday, 29 October 2007

Postgresql client for Limbo update

http://plan9.bell-labs.com/sources/contrib/maht/limbo/pg/

I finally forced myself to fix md5 login on the postgresql client.

The docs say its 'md5' || md5(password || salt)
when it is actually 'md5' || md5(md5(password || username) || salt)

pgfuncs outputs all the functions for a particular user/database as a text file you can import so you could do something like

% pgfuncs ip port username password database | sed 's/foo/bar/g' | psql -U username database

if you'd worked out how to get emu to run from the command line, unlike me :(

No comments: