How to compile and install a PostgreSQL database in centos

Source: Internet
Author: User
Tags postgresql psql readline centos


Readline is an open-source cross-platform library that provides interactive text editing. Postgresql requires readline support.
Https://ftp.postgresql.org/pub/source/v9.3.5/postgresql-9.3.5.tar.gz wget-c
[Root @ rootop postgresql-9.3.5] # yum install readline-devel


[Root @ rootop postgresql-9.3.5] #./configure -- prefix =/usr/local/pgsql
[Root @ rootop postgresql-9.3.5] # make
[Root @ rootop postgresql-9.3.5] # make install

Add a system account:

[Root @ rootop ~] # Useradd S
[Root @ rootop ~] # Passwd IPVS

Create a data directory:

[Root @ rootop ~] # Mkdir/usr/local/pgsql/data
[Root @ rootop ~] # Chown postgres: postgres/usr/local/pgsql/data/

Initialize the database:

[Root @ rootop ~] # Su postgres # switch to postgres for user execution

[S @ rootop ~] $/Usr/local/pgsql/bin/initdb-D/usr/local/pgsql/data/
You can use/usr/local/pgsql/bin/postgres-D/usr/local/pgsql/data/
OR/usr/local/pgsql/bin/pg_ctl-D/usr/local/pgsql/data/-l logfile start to start the service.

It is recommended that the following script start method listen to Port 5432 on tcp after it is started.

[S @ rootop ~] $ Lsof-I: 5432
Command pid user fd type device size/OFF NODE NAME
IPVS 5140 IPVs 3u IPv4 2394876345 0t0 TCP localhost: IPVS (LISTEN)

Copy the management script (root operation ):

[Root @ rootop postgresql-9.3.5] # cp contrib/start-scripts/linux/etc/init. d/postgresql
[Root @ rootop postgresql-9.3.5] # chmod o + x/etc/init. d/postgresql

Edit the startup script. Note the following information:

# Installation path
Prefix =/usr/local/pgsql
# Data Directory
PGDATA = "/usr/local/pgsql/data"
# Start a user
PGUSER = postgres
# Log path
PGLOG = "$ PGDATA/serverlog"
Then, you can manage it through service postgresql start | stop | restart | reload | status.

Start startup:

[Root @ AY131126202614070132Z ~] # Chkconfig postgresql on

Related configuration files:
You can configure the listening address, port, and number of connections through/usr/local/pgsql/data/postgresql. conf.
Listen_addresses =
Port =
Max_connections =
You can use/usr/local/pgsql/data/pg_assist.conf to configure the addresses that allow remote connection.
Host all 127.0.0.1/32 trust

Log on to the database:


[Root @ AY131126202614070132Z ~] #/Usr/local/pgsql/bin/psql-h 127.0.0.1-d postgres-U postgres
Psql (9.3.5)
Type "help" for help.
 
S = # \ l # View existing databases
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
----------- + ---------- + ------------- + -----------------------
Postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
Template0 | postgres | UTF8 | en_US.UTF-8 | = c/postgres +
| Postgres = CTc/postgres
Template1 | postgres | UTF8 | en_US.UTF-8 | = c/postgres +
| Postgres = CTc/postgres
(3 rows)
 
S = # \ q # exit

Parameters supported by psql can be obtained through/usr/local/pgsql/bin/psql -- help.
Installation is complete.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.