安装postgreSQL出现configure:error:readline library not found解决方法及pg安装全过程

 
在安装postgreSQL的过程中遇到一个问题,在执行 configure
过程中报以下错误,configure: error: readline library not found ,可是我在系统中安装
readline 包了,

1 环境信息

2 根据提示,测试了下 configre命令,果然报这个错
[root@HK81-107 postgresql-9.0.0]# ./configure
checking build system type... i686-pc-linux-gnu
checking host system type... i686-pc-linux-gnu
checking which template to use... linux
checking whether to build with 64-bit integer date/time support... yes
checking whether NLS is wanted... no
checking for default port number... 5432
checking for block size... 8kB
checking for segment size... 1GB
checking for WAL block size... 8kB
checking for WAL segment size... 16MB
checking for gcc... gcc
checking for C compiler default output file name... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for suffix of executables...
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ISO C89... none needed
checking if gcc supports -Wdeclaration-after-statement... yes
checking if gcc supports -Wendif-labels... yes
checking if gcc supports -fno-strict-aliasing... yes
checking if gcc supports -fwrapv... yes
checking whether the C compiler still works... yes
checking how to run the C preprocessor... gcc -E
checking allow thread-safe client libraries... yes
checking whether to build with Tcl... no
checking whether to build Perl modules... no
checking whether to build Python modules... no
checking whether to build with GSSAPI support... no
checking whether to build with Kerberos 5 support... no
checking whether to build with PAM support... no
checking whether to build with LDAP support... no
checking whether to build with Bonjour support... no
checking whether to build with OpenSSL support... no
checking for grep that handles long lines and -e... /bin/grep
checking for egrep... /bin/grep -E
checking for ld used by GCC... /usr/bin/ld
checking if the linker (/usr/bin/ld) is GNU ld... yes
checking for ranlib... ranlib
checking for strip... strip
checking whether it is possible to strip libraries... yes
checking for ar... ar
checking for tar... /bin/tar
checking whether ln -s works... yes
checking for gawk... gawk
checking for a thread-safe mkdir -p... /bin/mkdir -p
checking for bison... no
configure: WARNING:
*** Without Bison you will not be able to build PostgreSQL from CVS nor
*** change any of the parser definition files.  You can obtain Bison from
*** a GNU mirror site.  (If you are using the official distribution of
*** PostgreSQL then you do not need to worry about this, because the Bison
*** output is pre-generated.)
checking for flex... no
configure: WARNING:
*** Without Flex you will not be able to build PostgreSQL from CVS nor
*** change any of the scanner definition files.  You can obtain Flex from
*** a GNU mirror site.  (If you are using the official distribution of
*** PostgreSQL then you do not need to worry about this because the Flex
*** output is pre-generated.)
checking for perl... /usr/bin/perl
configure: using perl 5.8.8
checking for main in -lm... yes
checking for library containing setproctitle... no
checking for library containing dlopen... -ldl
checking for library containing socket... none required
checking for library containing shl_load... no
checking for library containing getopt_long... none required
checking for library containing crypt... -lcrypt
checking for library containing fdatasync... none required
checking for library containing gethostbyname_r... none required
checking for library containing shmget... none required
checking for -lreadline... no
checking for -ledit... no
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.
Use --without-readline to disable readline support.

     根据提示,应该是没有安装 readline包。

3 检查系统是否安装 readline 包
[root@HK81-107 postgresql-9.0.0]# rpm -qa | grep readline
readline-5.1-3.el5

   说明系统已经安装了 readline包。

4 通过 yum 搜索相关的 readline 包
[root@HK81-107 postgresql-9.0.0]# yum search readline
lftp.i386 : A sophisticated file transfer program
lftp.i386 : A sophisticated file transfer program
php-readline.i386 : Standard PHP module provides readline library support
lftp.i386 : A sophisticated file transfer program
readline.i386 : A library for editing typed command lines.
compat-readline43.i386 : The readline 4.3 library for compatibility with older software.
readline-devel.i386 : Files needed to develop programs which use the readline library.
readline.i386 : A library for editing typed command lines.

 根据提示,有一个包引起了注意 "readline-devel", 猜想可能与这个包有关。
 
5 安装 readline-devel 包
[root@HK81-107 postgresql-9.0.0]# yum -y install -y readline-devel
Setting up Install Process
Parsing package install arguments
Resolving Dependencies
--> Running transaction check
---> Package readline-devel.i386 0:5.1-3.el5 set to be updated
--> Processing Dependency: libtermcap-devel for package: readline-devel
--> Running transaction check
---> Package libtermcap-devel.i386 0:2.0.8-46.1 set to be updated
--> Finished Dependency Resolution

Dependencies Resolved

=============================================================================
 Package                 Arch       Version          Repository        Size
=============================================================================
Installing:
 readline-devel          i386       5.1-3.el5        base              146 k
Installing for dependencies:
 libtermcap-devel        i386       2.0.8-46.1       base               56 k

Transaction Summary
=============================================================================
Install      2 Package(s)        
Update       0 Package(s)        
Remove       0 Package(s)        

Total download size: 201 k
Downloading Packages:
(1/2): libtermcap-devel-2 100% |=========================|  56 kB    00:00    
(2/2): readline-devel-5.1 100% |=========================| 146 kB    00:00    
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing: libtermcap-devel             ######################### [1/2]
  Installing: readline-devel               ######################### [2/2]

Installed: readline-devel.i386 0:5.1-3.el5
Dependency Installed: libtermcap-devel.i386 0:2.0.8-46.1
Complete!

6 再次执行 configure 成功。

7 还有一种解决方法:在configure 加上参数 --without-readline ,不过这样就不可以在命令行里面输入了,所以不建议这样。。。

8 configure 成功之后接着就是make了

9 make之后就是make install之后安装成功的话就会出现如下图所示的界面

 

图片

 10.修改postgreSQL安装目录的权限,默认的安装目录在/usr/local/pgSQL下

修改权限命令为chmod -R 777 /usr/local/pgSQL

运行之后pgSQL目录下面的所有文件都会有XWR(X:可执行,W:可写,R:可读)权限。命令中的-R参数说明是递归的把文件夹pgSQL目录及其目录下的所有文件都修改为相应的权限,777就是代表加上对本用户,本用户组的其他用户和不是这个组的用户增加XWR权限。

 

11.

到此,PostgreSQL的安装完成了,接下来可以试着用用这个开源数据库啦…

1):首先是初始化数据库。进入刚刚安装PG的文件夹/home/pg/postgr(这是我安装pg的目录,默认的安装目录是在/usr/local/pgSQL下),输入./bin/initdb –D ../data. 这里的命令格式还需要查明白,特别是-D等参数的意义。这样会在postgr下面产生一个data文件夹。

2):启动数据库服务器。./bin/postmaster –D ./data&. 其中&的意义需要弄明白,差这一个符号就会导致一定的问题,貌似启动数据库服务器还可以使用另外的命令:/bin/postgres -D ./data 或者是 ./bin/pg_ctl -D ./data -l logfile start。这些命令的区别可以自己查查手册或者咨询一下助教。

 

图片

 

3):在另外一个命令行下面,创建一个本地数据库。./bin/createdb testdb,其中testdb是数据库名。在data目录下会产生一个文件夹

 

图片

 

4):链接数据库服务器。./bin/psql testdb. 此时,输入help可以获得帮助。见下图

 

图片

 

 

5):访问数据库。这里就是输入sql命令了,以后调试的入口就是这里吧。结束后按\q退出。

 

6):最后是关闭数据库服务器。./bin/pg_ctl stop –D ./data.

12.That's all!

 

### 安装前准备 为了在 Ubuntu 18.04 上成功离线安装 PostgreSQL,需要预先获取并准备好所有必需的依赖包。由于 `readline` 库缺失导致配置失败的问题已经出现过,在此情况下应确保所有必要的库文件都已下载。 ### 下载所需软件包及其依赖项 对于在线环境中的准备工作如下: ```bash sudo apt-get update sudo apt-cache depends postgresql-9.6 | grep Depends: | cut -d ' ' -f 2- | xargs sudo apt-get download ``` 上述命令会列出并下载 PostgreSQL 及其所有直接依赖关系到当前目录下[^1]。然而这一步骤需在一个可以联网的相同架构和版本的 Ubuntu 环境中完成。 ### 处理特定依赖问题 针对 `configure: error: readline library not found` 错误,除了 PostgreSQL 主程序外还需要额外下载 libreadline 开发库以及相关工具链以便编译源码: ```bash apt-get source postgresql-9.6 sudo apt-get build-dep postgresql-9.6 sudo apt-get install libreadline-dev ``` 以上步骤同样适用于有网络连接的情况下收集所需的 deb 文件用于后续离线环境中使用[^2]。 ### 编译与安装过程 将之前从其他机器上获得的所有 .deb 文件传输至目标主机后,可以通过 dpkg 命令来进行批量安装: ```bash cd /path/to/debs/ sudo dpkg -i *.deb ``` 如果遇到任何未解决的依赖关系冲突,则可能需要进一步调整或手动处理这些依赖性问题。 另外一种方法是从官方发布的 tarball 中自行构建 PostgreSQL : ```bash tar xf postgresql-13.8.tar.gz cd postgresql-13.8 ./configure --with-readline make sudo make install ``` 注意这里指定了 `--with-readline` 参数来确保 configure 能够找到正确的库路径。 ### 配置服务启动 最后设置 PostgreSQL 自动随系统启动,并创建初始数据库集群: ```bash sudo systemctl enable postgresql.service sudo pg_createcluster 13 main --start ``` 请根据实际安装版本号替换上面命令中的 “13”。
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值