PostgreSQL, also known as Postgres, is a free and open-source relational database management system emphasizing extensibility and technical standards compliance. It is designed to handle a range of workloads, from single machines to data warehouses or Web services with many concurrent users.
It is the default database for macOS Server, and is also available for Linux, FreeBSD, OpenBSD, and Windows.
- Create a database in PostgreSQL
- Create read only user at PostgreSQL
- Install PostgreSQL on CentOS 7 — PostgreSQL is a part of default CentOS repositories, so yum can be used to install it.
- PostgreSQL Automated backup on CentOS — PostgreSQL provides pg_dump to backup your database in a single file easily. You can backup your database based on your schedule combined with cron job on your CentOS.