Trying some inline processing.js.
From here :
UPDATE pg_database SET datistemplate=FALSE WHERE datname='template1';
DROP DATABASE template1;
CREATE DATABASE template1 WITH owner=postgres template=template0 encoding='UTF8';
UPDATE pg_database SET datistemplate=TRUE WHERE datname='template1';
Gardians of the Galaxy was great.
I placed an iPhone screen down on my Nexus 4. The Nexus got confused, took a picture, then rebooted to contemplate what had just happened.
Download Postgres.app from postgresapp.com. Unzip into /Applications, then run it.
To get psycopg2 to then install do:
PATH=$PATH:/Applications/Postgres.app/Contents//Versions/9.3/bin/ pip install psycopg2
Tada! Your done and without having had to use fink or brew.
New experience: a hard pretzel so fresh that the insides are still soft. Yum.
This is a note for my future reference.
zone example.com/IN: journal rollforward failed: journal out of sync with zone
zone example.com/IN: not loaded due to errors.
While named isn’t running, remove the
.jnl file for the example.com zone. It will be in the same directory as the zone files. Restart named and the error should be gone.
This error occurs if you have dynamic entries (say pushed by in by a DHCP server or other automatic mechanism) in a zone and then also change the zone files on disk (say deploying updates from a manual edit).
To prevent this in the future, freeze a zone before changing the zone file, then thaw after.
rndc freeze example.com
rndc reload example.com
rndc thaw sxample.com
Where I learned about this: thedumbterminal.co.uk
How to convert audio format in a video file:
ffmpeg -i input.mkv -vcodec copy -acodec ac3 -ab 448k output.mkv