PostgreSQL for MariaDB and MySQL Admins

https://www.socallinuxexpo.org/scale/22x/presentations/understanding-postgresql-mysql-developer-and-dba

Installation of PostgreSQL

• apt/dnf install
• other methods (distro repo, PostgreSQL repo, tar.gz, packages download, compile, container)
• Different Branches/Forks of PostgreSQL

Operations

• systemctl stop/start/status
• journalctl
• error logging

Navigation

See also here.

• psql (mariadb/mysql)
• other CLI tools
• GUI tools

User/Accounts

• Create user/accounts
• Roles

Databases/Schema/Relation/Tuple

• Cluster (Instance, [mariadbd], [mysqld], has nothing to do with a HA Cluster (M/S, failover, Galera)
  https://www.postgresql.org/docs/current/creating-cluster.html
  https://stackoverflow.com/questions/12908205/whats-a-postgresql-cluster-and-how-do-i-create-one
• Database / Catalog (does NOT exists, Catalog in MariaDB 11.7?)
  • postgres, template0, template1
• Schema (Database, Schema)
• Relation (Table, Sequence?)
• Tuple (Row)

Operation tasks

• Creating a new Database Cluster: https://www.postgresql.org/docs/current/creating-cluster.html
• Create a DATABASE
• Create a SCHEMA
• VACUUM See also here
  • monitoring/maintenance/ (Autovacuum daemon)
• Upgrade, see also collation
• Backup / Restore / PiTR
  • mariadb-dump/mysqldump
  • mariadb-backup/xtrabackup
  • mariadb-binlog/mysqlbinlog

Development / Transactions

• Autocommit

High Availability (HA)

• Replication: Logical, Physical

Sources

• Official PostgreSQL Documentation
• Download: …
• Planet PostgreSQL

Notes

• See our MariaDB/MySQL trainings.
• See also Spickliste
• See also PostgreSQL for a rusty MySQL brain