Summary
In this chapter, we have explored some extensions and some tools available for PostgreSQL. We have chosen not to provide a rundown of everything that is available for PostgreSQL, but instead, we have focused specifically on some tools and extensions that save DBAs time. We have talked about pgbackrest
, which is a very useful tool for managing recovery and PITR. We also talked about pgloader
, a powerful tool used to migrate from other DBMS to PostgreSQL. Then we showed a simple example of how to migrate from MariaDB to PostgreSQL.