PostgreSQL 9.6.1安装
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了PostgreSQL 9.6.1安装,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含4455字,纯文字阅读大概需要7分钟。
内容图文
![PostgreSQL 9.6.1安装](/upload/InfoBanner/zyjiaocheng/473/9c8e58bfd9cd4a03907eef8930b93ffe.jpg)
[root@rhel7 ~]# make --version
GNU Make 3.82
Built for x86_64-redhat-linux-gnu
2.You need an ISO/ANSI C compiler (at least C89-compliant). Recent versions of GCC are recommended
[root@rhel7 ~]# gcc --version
gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-4)
3. tar is required to unpack the source distribution, in addition to either gzip or bzip2.
4.The GNU Readline library is used by default.
readline
readline-devel
libedit
Optional
perl 5.8 or later
python
Kerberos
OpenSSL
OpenLDAP
and/or PAM
Flex 2.5.31 or later
Bison 1.875 or later
useradd pguser
su - pguser
tar -zxvf postgresql-9.6.1.tar.gz
Install
cd postgresql-9.6.1
./configure
默认安装目录/usr/local/pgsql,可以使用--prefix=path进行修改,./configure --help
make
The last line displayed should be:
All of PostgreSQL successfully made. Ready to install.
su (使用root安装)
make install
PostgreSQL installation complete.
Set the environment variables for pguser
mkdir /usr/local/pgsql/data #PostgreSQL数据存储目录
chown pguser:pguser /usr/local/pgsql/data
export LD_LIBRARY_PATH=/usr/local/pgsql/lib
export PG_HOME=/usr/local/pgsql
export PATH=$PG_HOME/bin/:$PATH
export PGDATA=/usr/local/pgsql/data
Initilize the DBServer
(使用pguser)
[pguser@rhel7 ~]$ initdb -D /usr/local/pgsql/data The files belonging to this database system will be owned by user "pguser". This user must also own the server process. The database cluster will be initialized with locale "en_US.UTF-8". The default database encoding has accordingly been set to "UTF8". The default text search configuration will be set to "english". Data page checksums are disabled. fixing permissions on existing directory /usr/local/pgsql/data ... ok creating subdirectories ... ok selecting default max_connections ... 100 selecting default shared_buffers ... 128MB selecting dynamic shared memory implementation ... posix creating configuration files ... ok running bootstrap script ... ok performing post-bootstrap initialization ... ok syncing data to disk ... ok WARNING: enabling "trust" authentication for local connections You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb. Success. You can now start the database server using: pg_ctl -D /usr/local/pgsql/data -l logfile start
Start the DBServer
[pguser@rhel7 ~]$ postgres -D /usr/local/pgsql/data >logfile 2>&1 & [1] 13799 [pguser@rhel7 ~]$ ps -ef |grep postgre pguser 13799 4377 0 12:37 pts/0 00:00:00 postgres -D /usr/local/pgsql/data pguser 13801 13799 0 12:37 ? 00:00:00 postgres: checkpointer process pguser 13802 13799 0 12:37 ? 00:00:00 postgres: writer process pguser 13803 13799 0 12:37 ? 00:00:00 postgres: wal writer process pguser 13804 13799 0 12:37 ? 00:00:00 postgres: autovacuum launcher process pguser 13805 13799 0 12:37 ? 00:00:00 postgres: stats collector process pguser 13807 4377 0 12:37 pts/0 00:00:00 grep --color=auto postgre
连接测试
[pguser@rhel7 ~]$ psql --list List of databases Name | Owner | Encoding | Collate | Ctype | Access privileges -----------+--------+----------+-------------+-------------+------------------- postgres | pguser | UTF8 | en_US.UTF-8 | en_US.UTF-8 | template0 | pguser | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/pguser + | | | | | pguser=CTc/pguser template1 | pguser | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/pguser + | | | | | pguser=CTc/pguser (3 rows) [pguser@rhel7 ~]$ psql postgres psql (9.6.1) Type "help" for help. postgres=# select version(); version --------------------------------------------------------------------------------------------------------- PostgreSQL 9.6.1 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-4), 64-bit (1 row) postgres=# select current_date; date ------------ 2016-12-01 (1 row) postgres=# \q
本文出自 “DBA Fighting!” 博客,请务必保留此出处http://hbxztc.blog.51cto.com/1587495/1878425
PostgreSQL 9.6.1安装
标签:postgresql 安装
本文系统来源:http://hbxztc.blog.51cto.com/1587495/1878425
内容总结
以上是互联网集市为您收集整理的PostgreSQL 9.6.1安装全部内容,希望文章能够帮你解决PostgreSQL 9.6.1安装所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。