In Chapter 12, Troubleshooting PostgreSQL, we learned 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 of you may still be suffering from the pain caused by commercial database license costs. I want to give all of you out there a way out and show you how data can be moved from some proprietary system to PostgreSQL. Moving to PostgreSQL makes sense not only 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, 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

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