nf is the main database configuration file. Editing the nf and pg_hba.conf configuration files. In the process, it will ask you to enter the password from the postgres super user of the postgres database. app/postgresql/bin/initdb -D /app/postgresql/pgdatabase/data/ -U postgres -W Initialization is the process of creating all the necessary directories for the database itself. The assembly procedure will take about 5 minutes.Īfter the assembly, we begin the process of installing the database itself. We collect the DBMS from the source files. app/postgresql/build/configure -prefix=/app/postgresql In the /app/postgresql/build directory, run: And now we can delete the archive itself. Now it starts to unpack the archive itself.Īfter unpacking, we get the postgresql-14.1 directory.Ĭhange the name of postgresql-14.1 to build. We will download the database archive on the official website.Īll further actions are performed under the postgres user.Īfter downloading the archive, move it to the /app/postgresql directory. Now let's assign the new postgres owner we created to the /app root directory. sudo mkdir -p /app/postgresql/pgdatabase/logĮnough for now, then there will be another directory with utilities for managing the database. sudo mkdir -p /app/postgresql/pgdatabase/data We create directories where the subd and the database will be stored. Create a local user on the server named postgres.Ĭreate a postgres user and set a password for it. sudo dnf install gcc zlib-devel readline-devel make We create our environment for the database.īefore installation, it is necessary to install important packages without which the installation of the database itself will not be possible.Editing nf and pg_hba.conf configuration files.Create a local user on the server named postgres.PostgreSQL is an open source generic object-relational database management system that is a real alternative to commercial databases. At the time of this writing, the latest version of the PostgreSQL database is 14.1. In this article, we will discuss how to install a PostgreSQL database server on Linux from source.
0 kommentar(er)
