Shulou(Shulou.com)06/01 Report--

Recently contacted the installation of postgresql, and share it with you.

First, a brief introduction

PostgreSQL is a very complex object-relational database management system (ORDBMS), and it is also the most powerful, rich and complex free software database system at present. Some features are not even available in commercial databases. This database research project, which originated in BSD, has now evolved into an international development project and has a very wide range of users.

Advantages: http://www.cnblogs.com/zhangpengme/archive/2011/12/01/2271092.html

Official website: http://www.postgresql.org/ (there are various packages and instructions on the official website, very detailed)

Two and three installation processes

A. RPM package installation

1. Check if PostgreSQL is installed

Rpm-qa | grep postgres

If already installed, use the rpm-e command to uninstall.

two。 Download the RPM package

# wget http://yum.postgresql.org/9.2/redhat/rhel-6-i386/postgresql92-contrib-9.2.4-1PGDG.rhel6.i686.rpm

# wget http://yum.postgresql.org/9.2/redhat/rhel-6-i386/postgresql92-libs-9.2.4-1PGDG.rhel6.i686.rpm

# wget https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-centos96-9.6-3.noarch.rpm

3. Install PostgreSQL, pay attention to the installation sequence

# rpm-ivh postgresql92-libs-9.2.4-1PGDG.rhel6.i686.rpm

# rpm-ivh postgresql92-9.2.4-1PGDG.rhel6.i686.rpm

# rpm-ivh postgresql92-server-9.2.4-1PGDG.rhel6.i686.rpm

# rpm-ivh postgresql92-contrib-9.2.4-1PGDG.rhel6.i686.rpm

4. Initialize the PostgreSQL library

Initialization is prompted when the PostgreSQL service is started for the first time.

# service postgresql-9.2 initdb

5. Start the service

# service postgresql-9.2 start

6. Add the PostgreSQL service to the startup list

# chkconfig postgresql-9.2on

# chkconfig-- list | grep postgres

7. Modify the password of the PostgreSQL database user postgres (note that it is not a linux system account)

PostgreSQL database default will create a postgres database user as the database administrator, the default password is empty, we need to change to the specified password, here set to 'postgres'.

# su-postgres

$psql

# ALTERUSER postgres WITH PASSWORD 'postgres'

# select*from pg_shadow

B. yum installation

1. Uninstall the PostgreSQL you just installed

# / etc/init.d/postgresql-9.2 stop / / stop PostgreSQL service

/ / View installed packages

# rpm-qa | grep postgres

/ / Uninstall

# rpm-e postgresql92-server-9.2.4-1PGDG.rhel6.i686

# rpm-e postgresql92-contrib-9.2.4-1PGDG.rhel6.i686

# rpm-e postgresql92-9.2.4-1PGDG.rhel6.i686

# rpm-e postgresql92-libs-9.2.4-1PGDG.rhel6.i686

2. Yum installation

If it is the default yum installation, a lower version of PostgreSQL 8.4 will be installed, which does not meet our requirements.

We use PostgreSQL Yum Repository to install the latest version of PostgreSQL.

2.1 install PostgreSQL yum repository

# rpm-I http://yum.postgresql.org/9.2/RedHat/rhel-6-x86_64/pgdg-redhat92-9.2-7.noarch.rpm

2.2 install the new version of PostgreSQL

# yum install postgresql92-server postgresql92-contrib

2.3 View installation

3. Initialize and start the database

Configuration file: / var/lib/pgsql/data/pg_hba.conf

4. test

Other steps such as method A.

c. Source package installation

1. Download the Postgresql source code

Wget http://ftp.postgresql.org/pub/source/v9.0.3/postgresql-9.0.3.tar.bz2

Wget https://ftp.postgresql.org/pub/source/v9.6.2/postgresql-9.6.2.tar.bz2

2. Extract the file

Tar xjvf postgresql-9.0.3.tar.bz2

3. Enter the decompressed directory

Cd postgresql-9.0.3/

4. View INSTALL

The Short Version section of the INSTALL file explains how to install the postgresql command, and the Requirements section describes the lib that the installation of postgresql depends on. If it is long, try configure first. If error appears, then you need to check whether the requirements of Requirements are met.

Short Version

. / configure

Gmake

Su

Gmake 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

5. Execute the Short Version command in the INSTALL file and start compiling and installing the postgrepsql database.

. / configure-prefix=/usr/local/pgsql-with-perl-with-python-with-libxml-with-libxslt

Configure: error: readline library not found

If you have readline already installed, see config.log for details on the

Failure. It is possible the compiler isnt looking in the proper directory.

Yum install-y readline-devel

(sudo apt-get install libreadline5-dev & & sudo apt-get install zlib1g-dev)

Configure: error: library 'xslt' is required for XSLT support

Yum install libxslt libxslt-devel

Configure: error: header file is required for Python

Yum install python python-devel

Configure: error: could not determine flags for linking embedded Perl.

Yum install perl-ExtUtils-Embed

After installing the readline package, re-configure, successful.

6 、 make

7 、 make install

8. Add user postgres

Useradd postgres

9. Create a database file storage folder

Mkdir / usr/local/pgsql/data

# mkdir / data/pgsql

10. Change the permissions of the folder in the previously created data directory

Chown postgres / usr/local/pgsql/data

# chown postgres / data/pgsql

11. Switch users

Su-postgres

12. Bind the database file storage directory

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

# export PATH=$PATH:/usr/local/pgsql/bin/

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

13. Start the database

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

[1] 18635

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

[1] 18635

14. Create a database test

/ usr/local/pgsql/bin/createdb test

15. Connect to the test database

/ usr/local/pgsql/bin/psql test

Psql (9.0.3)

Type "help" for help.

Test=#

16. Create the table table1

Test=# create table table1 (

Test (# id integer

Test (#)

CREATE TABLE

Test=#

17. Insert a record into the table1 table

Test=# insert into table1 values (1)

INSERT 0 1

18. Query the record you just inserted

Test=# select * from table1

Id

-

one

III. Client installation

Because the scope of application of postgre is very small for us, it is not suitable for our time management to simply learn his command line.

So we can download a client, do some simple operations, and recommend the navicat official website to download the postgresql client.

Https://www.navicat.com.cn/download

-

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.