I have a server that hosts my Subversion code base. That server is currently a Windows Server 2003 box, and my IT administrator wants to update it to Windows Server 2008. This means that I’m going to need to move my Subversion repository while the server gets built up and was wondering what the best … Read more
Trying to replicate a database from one system to another. The versions involved are 9.5.0 (source) and 9.5.2 (target). Source db name is foodb with owner pgdba and target db name will be named foodb_dev with owner pgdev. All commands are run on the target system that will host the replica. The pg_dump command is: … Read more
I have implemented a BackupAgentHelper using the provided FileBackupHelper to backup and restore the native database I have. This is the database you typically use along with ContentProviders and which resides in /data/data/yourpackage/databases/. One would think this is a common case. However the docs aren’t clear on what to do: http://developer.android.com/guide/topics/data/backup.html. There is no BackupHelper … Read more
When I began, I used pg_dump with the default plain format. I was unenlightened. Research revealed to me time and file size improvements with pg_dump -Fc | gzip -9 -c > dumpfile.gz. I was enlightened. When it came time to create the database anew, # create tablespace dbname location ‘/SAN/dbname’; # create database dbname tablespace … Read more
I need to migrate from one Mac to another, and want Sublime Text 2 on a new computer to have all the same configuration/plugins I have installed on the old one. Is there some folder(s) I could just copy and restore on another one to replicate everything? Answer I just set up a good solution … Read more
This question already has answers here: How can I recover a lost commit in Git? (7 answers) Closed 6 years ago. I am surprised, I couldn’t find the answer to this on SO. Can we recover/restore deleted commits in git? For example, this is what I did: # Remove the last commit from my local … Read more
When I backup or restore a database using MS SQL Server Management Studio, I get a visual indication of how far the process has progressed, and thus how much longer I still need to wait for it to finish. If I kick off the backup or restore with a script, is there a way to … Read more
The following figure (from the official doc) describes the well-known lifecycle of an Android activity: On the other hand, when the activity is destroyed by the system (for example because memory needs to be reclaimed), the state of the activity is sometimes automatically saved and restored by means of the methods onSaveInstanceState() and onRestoreInstanceState(), as … Read more
I deleted a file from a repo and now want to put it back. The best I can figure out is to: update to the revision before the delete copy the files elsewhere update to head copy the files back add them commit That just smells bad and it looses all history to boot. There … Read more
When I want to unstage a staged file, all of my Git tutorials show something like: $ git add * $ git status On branch master Changes to be committed: (use “git reset HEAD <file>…” to unstage) renamed: README.md -> README modified: CONTRIBUTING.md This hint tells us to use git reset for unstaging a staged … Read more
