Monthly Archives: August 2011

git cheatsheet

24 Aug

browsing the git history in a compact yet still highly condensed view containing all important information: git log —graph —source —oneline —branches —tags

duplicating a postgresql DB

23 Aug

e.g. for testing purposes before touching valuable data… set the DB names ORIG_DB=“orig_db_name” NEW_DB=“new_db_name” create a dump (make sure to use a user having access rights to the db) TSTAMP=$(date +%F_%H-%M) FILE_ORIG=”${ORIG_DB}_${TSTAMP}.sql” pg_dump -f ${FILE_ORIG} —blobs —create ${ORIG_DB} adjust the … Read More »