Cause: my user couldn’t read /etc/hosts

Anyone thinking of signing up with Be Internet: be warned, it’s easier to join them than to leave. I’m currently having a fight with them because they insist the only way you can close an account with them and stop paying them money, is by phoning a telephone number and giving lots of security information including your date of birth. Not allowed to do it via their own “secure” account system…

rpm2cpio .rpm | cpio -vid (or -vt just to view contents)

Following their instructions to initialise the database, you get a complaing about /dev/null. This is because the default postgres user is installed with a shell of /dev/null. To change it, forget all the Unix stuff you know about administering users and do this sudo dscl . -change /Users/postgres UserShell /dev/null /bin/sh Or if you want to check first, check that the user exists sudo dscl . -list /Users UniqueID

Needed to do this: sudo locale-gen en_GB.UTF-8 sudo dpkg-reconfigure locales

sudo apt-get install update-manager-core sudo do-release-upgrade

There’s a bug in (at least some versions of) Ubuntu, which means the wrong library is being picked up. https://bugs.launchpad.net/ubuntu/+source/subversion/+bug/294648 Workaround: LD_PRELOAD=/usr/lib/libneon.so.27 svn

if for example, you want to apply a unique index, but you can’t because there’s duplicates in the table. SELECT name FROM mytable GROUP BY name HAVING COUNT(*) > 1;

new site…

svn propset svn:executable on