In this section, we will demonstrate how the principles and high-level processes we have looked at so far for MariaDB on CentOS can be applied to another platform. Taking a high-level view, these processes can be applied to almost any database and Linux platform, with the proper attention to detail. Here, we will install PostgreSQL Server onto Ubuntu Server, and then secure it by setting the root password—essentially, analogous to the process we have performed in the preceding section.
Let us get started by creating a role called installpostgres. In this role we will again define a template for the package downloads from the official PostgreSQL sources, this time—of course—tailoring it to the fact ...