PostgreSQL安装体验

PostgreSQL安装体验,第1张

概述今天开始利用闲暇时间来学点PGSQL。下面我贴出我的初次安装体验。 1、遇到两个错误:   1)、configure: error: readline library not found   解决方法:   安装libtermcap-devel-2.0.8-46.1.i386.rpm   和readline-devel-5.1-1.1.i386.rpm   安装过程就不多说了。   checkin 今天开始利用闲暇时间来学点PGsql。下面我贴出我的初次安装体验
1、遇到两个错误:
1)、configure: error: readline library not found
解决方法:
安装libtermcap-devel-2.0.8-46.1.i386.rpm
和readline-devel-5.1-1.1.i386.rpm
安装过程就不多说了。
checking for inflate in -lz... no
2)、configure: error: zlib library not found
解决方法:
安装zlib-devel-1.2.3-3.i386.rpm
然后./configurate;make;make install
如果到了这一步就表示安装成功了。
Postgresql installation complete.
PGsql 安装成功
2、后续设置
[root @localhost pgsql]# make dir /usr/local/pgsql/data
POSTGRE好像不能用ROOT来 *** 作。只能用普通用户。
[root @localhost pgsql]# adduser postgres
[root @localhost pgsql]# chown -R postgres /usr/local/pgsql/data/
初始化数据库:
[root @localhost pgsql]# su postgres
[postgres @localhost pgsql]$ ./bin/initdb -D /usr/local/pgsql/data/
The files belonging to this database system will be owned by user "postgres".
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.

fixing permissions on existing directory /usr/local/pgsql/data ... ok
creating subdirectorIEs ... ok
selecting default max_connections ... 100
selecting default shared_buffers/max_fsm_pages ... 32MB/204800
creating configuration files ... ok
creating template1 database in /usr/local/pgsql/data/base/1 ... ok
initializing pg_authID ... ok
initializing dependencIEs ... ok
creating system vIEws ... ok
loading system objects' descriptions ... ok
creating conversions ... ok
setting privileges on built-in objects ... ok
creating information schema ... ok
vacuuming database template1 ... ok
copying template1 to template0 ... ok
copying template1 to postgres ... ok

WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the -A option the
next time you run initdb.

Success. You can Now start the database server using:

./bin/postgres -D /usr/local/pgsql/data
or
./bin/pg_ctl -D /usr/local/pgsql/data -l logfile start

用POSTGRES用户启动PGsql服务进程
/usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data >logfile 2>&1 &
实际 *** 作
也可以这样启动PGsql服务进程
/usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l /usr/local/pgsql/logfile start
做成服务自动启动
[root@localhost start-scripts]# cp /usr/local/pgsql/contrib/start-scripts/linux /etc/init.d/pgsql
[root@localhost start-scripts]# chkconfig --add pgsql
[root@localhost start-scripts]# service pgsql status
pg_ctl: server is running (PID: 7019)
/usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data
[root@localhost start-scripts]# export PATH=$PATH:/usr/local/pgsql/bin/

[postgres @localhost ~]$ createdb t_girl
CREATE DATABASE
[postgres @localhost ~]$ psql t_girl
Welcome to psql 8.2.6,the Postgresql interactive terminal.

Type: \copyright for distribution terms
\h for help with sql commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit

t_girl=# select version();
version
----------------------------------------------------------------------------------------------------
Postgresql 8.2.6 on i686-pc-linux-gnu,compiled by GCC gcc (GCC) 4.1.1 20070105 (Red Hat 4.1.1-52)
(1 row)
t_girl=# \q
[postgres @localhost ~]$ dropdb t_girl
DROP DATABASE
更多见:
[url]http://www.pgsqldb.org/pgsqldoc-8.1c/postmaster-start.html[/url]

本文出自 “上帝,咱们不见不散!” 博客,转载请与作者联系!

总结

以上是内存溢出为你收集整理的PostgreSQL安装体验全部内容,希望文章能够帮你解决PostgreSQL安装体验所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错,欢迎将内存溢出网站推荐给程序员好友。

欢迎分享,转载请注明来源:内存溢出

原文地址: http://outofmemory.cn/sjk/1177146.html

(0)
打赏 微信扫一扫 微信扫一扫 支付宝扫一扫 支付宝扫一扫
上一篇 2022-06-02
下一篇 2022-06-02

发表评论

登录后才能评论

评论列表(0条)

保存