Here is a nice little tidbit I ran across some time ago… Ever delete a bunch of files from a git working copy, and then had to go in and tell git that you meant to delete them? For example: [jason@dc40 AppStruct]$ git status # On branch master # Changed but not updated: # (use [...]
Archive for May 16th, 2010
git add -u
Posted in Engineering, Software, Technique, tagged git, git add, scm, version control on May 16, 2010 | Leave a Comment »
PostgreSQL Dump and Restore Notes
Posted in Open Source, Software, System Administration, Technique, tagged database backup, pg_dump, pg_restore, PostgreSQL on May 16, 2010 | Leave a Comment »
The pg_dump and pg_restore commands provide excellent flexibility in storing a compressed dump file, and selectively restoring any part of it. I’ve found that dropping and re-creating the target database is the cleanest way to restore a dumpfile — no stray relations left to cause trouble. Unless you own all of the objects being restored, [...]