The PostgreSQL administration covers the most important PostgreSQL database server administration activities. We will discuss roles and groups administration, databases creation, tablespaces management, databases backup and restore.

PostgreSQL database and schema management

In this section, we will show you how to manage databases in PostgreSQL including creating databases, modifying existing database’s features and deleting databases. In addition, the schema management is covered.