In Chapter 12, Troubleshooting PostgreSQL, we saw how to approach the most common issues related to PostgreSQL troubleshooting. The important thing is to have a systematic approach to tracking down problems, which is exactly what is provided here.

The final chapter of this book is about moving from other databases to PostgreSQL. Many readers might still be suffering from the pain caused by commercial database license costs. I want to give all of those users out there a way out and show you how data can be moved from some proprietary system to PostgreSQL. Moving to PostgreSQL not only makes sense from a financial point of view, but also makes sense if you are looking for more advanced features and more flexibility. PostgreSQL has so much to offer, and at the time of writing this book, new features are being added daily. The same applies to the number of tools that are available to migrate to PostgreSQL. Things are getting better and better, and developers are publishing more and better tools all the time.

The following topics will be covered in this chapter:

• Migrating SQL statements to PostgreSQL
• Moving from Oracle to PostgreSQL
• Moving MySQL to PostgreSQL

By the end of this chapter, you should be able to move a basic database from some other system to PostgreSQL.