In the nf file, find the include_if_exists parameter and add the bd_nf values to it. In the pg_hba.conf file, comment out all the parameters, and add the text below:
The files are located in the directory - /app/postgresql/pgdatabase/data Pg_hba.conf - used to configure access to the database. 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
0 kommentar(er)
