SOAP: Error fetching http headers

http://php.blogaboutwhatever.com/2011/11/error-fetching-http-headers/

Git: cancel staged file update

With git log check which commit is one prior the update. Then you can reset it using:

git reset  filename
git checkout filename

Git: cancel merge

With git log check which commit is one prior the merge. Then you can reset it using:

git reset --hard commit_sha

PostgreSQL: upsert

With a lock: http://www.the-art-of-web.com/sql/upsert/
Discussion: http://www.depesz.com/2012/06/10/why-is-upsert-so-complicated/
PostgreSQL doc.: http://www.postgresql.org/docs/current/static/plpgsql-control-structures.html#PLPGSQL-UPSERT-EXAMPLE

OSX: use Clover Configurator

First mount EFI partition:
Identify EFI device

diskutil list

Then mount device, e.g.

mkdir /Volumes/EFI
sudo mount_msdos /dev/disk0s1 /Volumes/EFI

Then select /Volumes/EFI/EFI/CLOVER/config.plist in Clover configurator

OSX: Errors in audio_cloverALC-110_v1.0h

See https://github.com/toleda/audio_CloverALC/issues/43

OSX: Clover install on El Capitan

How To Install OS X Yosemite Using Clover

PostgreSQL: compile pgloader

Compile SBCL with core compression support:

git clone git://git.code.sf.net/p/sbcl/sbcl
cd sbcl
./make.sh --with-sb-core-compression --with-sb-thread
sudo ./install.sh

Compile pgloader:

git clone https://github.com/dimitri/pgloader.git
cd pgloader
make
sudo cp ./build/bin/pgloader /usr/bin

PostgreSQL: generate create table SQL

pg_dump -t 'my_schema.my_table' --schema-only