Shulou(Shulou.com)05/31 Report--

This article mainly introduces "the installation and startup method of PostgreSQL". In the daily operation, I believe that many people have doubts about the installation and startup method of PostgreSQL. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts about "installation and startup method of PostgreSQL". Next, please follow the editor to study!

Official document

Binary installation and startup:

Https://www.postgresql.org/download/linux/redhat/

Source code installation and startup:

Https://www.postgresql.org/docs/11/install-procedure.html

Https://www.postgresql.org/docs/11/creating-cluster.html

Https://www.postgresql.org/docs/11/server-start.html

Https://www.postgresql.org/docs/current/kernel-resources.html

Two methods

1. Binary installation (linux is the rpm package, windows is the exe installation file)

2. Source code installation, recommended installation method

Binary installation

Example: centos7_64 platform, database postgresql11, installation using yum

If you don't use yum, you can install it directly using rpm package. Download address of rpm package is https://yum.postgresql.org/rpmchart.php.

1. To install the yum source of RPM is to download a yum source pgdg-redhat-all.repo file of postgresql to the / etc/yum.repos.d directory. With this yum source, you can directly yum install postgresql11 and install the postgresql database.

Yum install

Https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm

2. To install the client, first execute search to see what PostgreSQL client is available for installation.

Yum search 'PostgreSQL client'

Yum install postgresql11

3. To install the server, first execute search to see what PostgreSQL server is available for installation. After the following steps are installed, the user postgres will be created automatically and the directory / usr/pgsql-11 will be created automatically

Yum search 'PostgreSQL server'

Yum install postgresql11-server

4. Initialize the database and enable boot auto-startup

/ usr/pgsql-11/bin/postgresql-11-setup initdb

Systemctl enable postgresql-11

Systemctl start postgresql-11

5. View the progress of postgresql

[root@zabbixtest2 ~] # ps-ef | grep postgres

Postgres 1527 1 0 01:13? 00:00:00 / usr/pgsql-11/bin/postmaster-D / var/lib/pgsql/11/data/

6. Connect to postgresql database

Su-postgres

Psql-l

Psql-d postgres

Source code installation

1. Set up the configuration of postgresql users and kernel resources, mainly involving / etc/security/limits.conf and / etc/sysctl.conf files. Similar to oracle, you also need to configure these two files.

2. Extract the tar package, enter the directory, use the root user to execute the following, and install the software to the / postgresql/pgsql directory with the final make install command.

. / configure-- prefix=/postgresql/pgsql

Make

Make install

3. Set the software installation directory / postgresql/pgsql authorized host user to postgresql

4. Edit the .bash_profile file of postgresql users, PATH= / postgresql/pgsql/bin: $PATH, LD_LIBRARY_PATH= / postgresql/pgsql/ lib

5. Initialize the database, either of the last two commands will do

Su-postgresql

Initdb-D / postgresql/pgsql/data

Pg_ctl-D / postgresql/pgsq l/data initdb

6. Start the postgresql program. Any of the following is fine. Official documents suggest using pg_ctl.

Postgres-D / postgresql/pgsql/data > logfile 2 > & 1 &

Pg_ctl start-D / postgresql/pgsql/data-l logfile

7. View the progress of postgresql

[root@zabbixtest1 ~] # ps-ef | grep postgres

Postgre+ 803 10 07:10 pts/0 00:00:00 / postgresql/pgsql/bin/postgres-D / postgresql/pgsql/data

8. Connect to the postgresql database and specify to connect to the postgres library

Psql-l

Psql-d postgres

Note: the psql command does not add a port or a database name, which means that the default entry port is 5432 and the database name is the same as the user name of the initial database initdb. For example, if the user name of the initial database initdb is A, then enter the A library by default. The default port of postgresql is 5432, and the default database is postgres, template0, template1.

If the port is not 5432, the error psql: FATAL: role "A" does not exist will be reported.

Because the instance port corresponding to the installation user "A" is other, the Owner of the port 5432 database is not "A"

If there is no "A" library at this time, there will be an error psql: FATAL: database "A" does not exist

Because the user "A" is installed, the "A" library is entered by default, but the "A" library does not exist.

9. Create a database called test

Createdb test

10. View database status

Pg_ctl status-D / postgresql/pgsql/data

11. Close the database

Pg_ctl stop-D / postgresql/pgsql/data

Official documentation Short Version brief steps

. / configure

Make

Su

Make install

Adduser postgres

Mkdir / usr/local/pgsql/data

Chown postgres / usr/local/pgsql/data

Su-postgres

/ usr/local/pgsql/bin/initdb-D / usr/local/pgsql/data

/ usr/local/pgsql/bin/postgres-D / usr/local/pgsql/data > logfile 2 > & 1 &

/ usr/local/pgsql/bin/createdb test

/ usr/local/pgsql/bin/psql test

At this point, the study on the "installation and startup method of PostgreSQL" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.