Databases¶
Running PostgreSQL and MariaDB: connecting, creating users and databases, granting rights, checking whether the server is alive and securing a fresh installation.
PostgreSQL¶
-
Connect, run SQL, inspect databases and roles.
-
Create a PostgreSQL role.
-
Create a PostgreSQL database.
-
Does the server accept connections?
-
Clusters, versions and ports (Debian, Ubuntu).
MariaDB¶
-
Connect, run SQL, manage users and rights.
-
Ping, status, processes and variables.
-
Secure a fresh installation.
From other chapters¶
-
Back up PostgreSQL databases. Covered in the chapter Backup.
-
Back up MariaDB and MySQL databases. Covered in the chapter Backup.
-
Check on which address the database listens. Covered in the chapter Network.
-
Open the database port only for application servers. Covered in the chapter Network.