Tyler Cowen at Marginal Revolution offers a cautionary tale on Social Security reform from Argentina.
In contrast, Chile, as Cowen notes, is the poster child for succesful Social Security reform. Here's a description of how it worked, from one of the architects.
This link, also provided in the Cowen post is another good source of information about the experience of other countries with public pension reform (as of 1999).