YUM Installation PostgreSQL
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了YUM Installation PostgreSQL,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含3357字,纯文字阅读大概需要5分钟。
内容图文
![YUM Installation PostgreSQL](/upload/InfoBanner/zyjiaocheng/470/2b4bd092b8954ae5aa95d714405db179.jpg)
- 1 Instructions
- 1.1 Configure your YUM repository
- 1.2 Install PGDG RPM file
- 1.3 Install PostgreSQL
- 1.4 Post-installation commands
- 1.4.1 Data Directory
- 1.4.2 Initialize
- 1.4.3 Startup
- 1.5 Control service
- 2 Removing
- 3 Support
- 4 After installation
Instructions
Configure your YUM repository
Locate and edit your distributions .repo file, located:
- On Fedora: /etc/yum.repos.d/fedora.repo and /etc/yum.repos.d/fedora-updates.repo, [fedora] sections
- On CentOS: /etc/yum.repos.d/CentOS-Base.repo, [base] and [updates] sections
- On Red Hat: /etc/yum/pluginconf.d/rhnplugin.conf [main] section
To the section(s) identified above, you need to append a line (otherwise dependencies might resolve to the postgresql supplied by the base repository):
exclude=postgresql*
Install PGDG RPM file
A PGDG file is available for each distribution/architecture/database version combination. Browse http://yum.postgresql.org and find your correct RPM. For example, to install PostgreSQL 9.4 on CentOS 6 64-bit:
yum localinstall http://yum.postgresql.org/9.4/redhat/rhel-6-x86_64/pgdg-centos94-9.4-1.noarch.rpm
Install PostgreSQL
To list available packages:
yum list postgres*
For example, to install a basic PostgreSQL 9.4 server:
yum install postgresql94-server
Other packages can be installed according to your needs.
Post-installation commands
After installing the packages, a database needs to be initialized and configured.
In the commands below, the value of <name> will vary depending on the version of PostgreSQL used.
For PostgreSQL version 9.0 and above, the <name> includes the major.minor version of PostgreSQL, e.g., postgresql-9.4
For versions 8.x, the <name> is always postgresql (without the version signifier).
Data Directory
The PostgreSQL data directory contains all of the data files for the database. The variable PGDATA is used to reference this directory.
For PostgreSQL version 9.0 and above, the default data directory is:
/var/lib/pgsql/<name>/data
For example:
/var/lib/pgsql/9.4/data
For versions 7.x and 8.x, default data directory is:
/var/lib/pgsql/data/
Initialize
The first command (only needed once) is to initialize the database in PGDATA.
service <name> initdb
E.g. for version 9.4:
service postgresql-9.4 initdb
If the previous command did not work, try directly calling the setup binary, located in a similar naming scheme:
/usr/pgsql-y.x/bin/postgresqlyx-setup initdb
E.g. for version 9.4:
/usr/pgsql-9.4/bin/postgresql94-setup initdb
Startup
If you want PostgreSQL to start automatically when the OS starts:
chkconfig <name> on
E.g. for version 9.4:
chkconfig postgresql-9.4 on
In RHEL 7+, try:
systemctl enable postgresql
Control service
To control the database service, use:
service <name> <command>
where <command> can be:
- start : start the database
- stop : stop the database
- restart : stop/start the database; used to read changes to core configuration files
- reload : reload pg_hba.conf file while keeping database running
E.g. to start version 9.4:
service postgresql-9.4 start
With RHEL 7.1+ and CentOS 7.1+, Systemd is introduced. Use this instead:
systemctl enable postgresql-9.4.service
systemctl start postgresql-9.4.service
Removing
To remove everything:
yum erase postgresql94*
Or remove individual packages as desired.
YUM Installation PostgreSQL
标签:
本文系统来源:http://www.cnblogs.com/UnGeek/p/5895432.html
内容总结
以上是互联网集市为您收集整理的YUM Installation PostgreSQL全部内容,希望文章能够帮你解决YUM Installation PostgreSQL所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。