#PostgreSQL 13 Installation on CentOS 7 | PostgreSQL DBA Course | SkillPedia

October 28, 2023

PostgreSQL 13 RPMs for CentOS
PostgreSQL can be installed using both sources and packages. To install PostgreSQL on CentOS, it is important that you have root access or sudo access to perform the installation using YUM
The server should be able to connect to the PGDG repository.
1. Go to https://postgresql.org/download and click on the operating system that you’ll be downloading the PostgreSQL packages for, such as Linux for CentOS or Ubuntu/Debian distributions.
2. Click on the appropriate distribution the packages are needed for.
3. After clicking on the appropriate distribution, we’ll land on the page that contains dropdowns, where we can choose the OS version and the PostgreSQL version. Once all the fields have been selected, we should see the steps to set up the PGDG repository and install the PostgreSQL server.
PGDG stands for the PostgreSQL Global Development Group. The packages can be downloaded from the URL given. From here, we can choose the version we wish to install so that the corresponding packages can be downloaded.
After installation, you should see that a Postgres user is automatically created. All the utilities needed to manage PostgreSQL are stored inside the bin directory (/usr/pgsql-13/bin) by default. So, it is always recommended to add the directory to PATH for ease.
Initializing a PostgreSQL cluster using initdb
After installation, we need to choose a directory where the data directory can be created. This data directory will be used to store the databases and the underlying objects we create. To create a data directory, we must use initdb.
The $PGDATA is the environment variable used by Postgres to identify its data directory. This variable can be optionally set in .bash_profile of the Postgres home directory to avoid passing the data directory location to initdb.
PostgreSQL, Postgre, PostgreSQL DBA, Postgre DBA, PostgreSQL DBA Course, PostgreSQL Training, Postgre DBA Course, Postgre DBA Training, PostgreSQL Installation, PostgreSQL Installation on CentOS 7, Installing Postgres, Postgres Installation,
Visit www.theskillpedia.com for Online Training on this technology