Tip #11 - Transact Your Migrations!

April 19th, 2008

If you are using Rails, you are most likely using migrations. Have you ever had a migration fail half way through? Have you ever then had to figure out how to find each change and revert it in the database? Would you like to never have to do that again? Here is how…

Read the rest of this entry
Posted by mikel Filed in PostgreSQL, Ruby on Rails, Ruby on Rails Tips
5 comments »

PostgreSQL on Windows - Startup Errors

April 16th, 2008

If you are using PostgreSQL on Windows and you get: FATAL: pre-existing shared memory block is still in use Or you get: HINT: Check if there are any old server processes still running, and terminate them. errors, here is how you fix it.

Read the rest of this entry
Posted by mikel Filed in PostgreSQL
0 comments »