装postgres数据库出问题!

数据库服务和管理,MySQL/PostgreSQL/Oracle/Sybase 等
回复
cetingraul
帖子: 7
注册时间: 2007-01-27 16:19
送出感谢: 0
接收感谢: 0

装postgres数据库出问题!

#1

帖子 cetingraul » 2007-07-09 17:26

root@ubuntu:/home/www/postgresql-8.2.1# ./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... no
checking whether NLS is wanted... no
checking for default port number... 5432
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 ANSI C... 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
configure: using CFLAGS=-O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing
checking whether the C compiler still works... yes
checking how to run the C preprocessor... gcc -E
checking allow thread-safe client libraries... no
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 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 egrep... grep -E
configure: using CPPFLAGS=-D_GNU_SOURCE
configure: using LDFLAGS=
checking for gawk... gawk
checking for flex... /usr/bin/flex
checking whether ln -s works... yes
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 tar... /bin/tar
checking for strip... strip
checking whether it is possible to strip libraries... yes
checking for bison... bison -y
checking for perl... /usr/bin/perl
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 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 isn't looking in the proper directory.
Use --without-readline to disable readline support.

本人比较菜,帮忙看一下是什么原因?谢谢
头像
forrid
帖子: 659
注册时间: 2007-04-23 17:40
送出感谢: 0
接收感谢: 0

#2

帖子 forrid » 2007-07-09 19:06

代码: 全选

./configure --without-readline

吾生也有涯,而知也无涯,以有涯随无涯,SB啊~~~~~~~~~~
cetingraul
帖子: 7
注册时间: 2007-01-27 16:19
送出感谢: 0
接收感谢: 0

#3

帖子 cetingraul » 2007-07-10 10:37

forrid 写了:

代码: 全选

./configure --without-readline
输入后出现:
root@ubuntu:/home/www/postgresql-8.2.1# ./configure --without-readline
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... no
checking whether NLS is wanted... no
checking for default port number... 5432
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 ANSI C... 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
configure: using CFLAGS=-O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing
checking whether the C compiler still works... yes
checking how to run the C preprocessor... gcc -E
checking allow thread-safe client libraries... no
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 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 egrep... grep -E
configure: using CPPFLAGS=-D_GNU_SOURCE
configure: using LDFLAGS=
checking for gawk... gawk
checking for flex... /usr/bin/flex
checking whether ln -s works... yes
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 tar... /bin/tar
checking for strip... strip
checking whether it is possible to strip libraries... yes
checking for bison... bison -y
checking for perl... /usr/bin/perl
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 shmget... none required
checking for inflate in -lz... no
configure: error: zlib library not found
If you have zlib already installed, see config.log for details on the
failure. It is possible the compiler isn't looking in the proper directory.
Use --without-zlib to disable zlib support.

这个又怎么解决?怎么把这些东西补全?
cetingraul
帖子: 7
注册时间: 2007-01-27 16:19
送出感谢: 0
接收感谢: 0

#4

帖子 cetingraul » 2007-07-11 11:45

通过:./configure --without-readline --without-zlib装好了(不知道有没问题)
现在客户端连不上去,提示密码错误,但是密码是没有错
cxczqfrx
帖子: 107
注册时间: 2007-07-11 11:10
送出感谢: 0
接收感谢: 0

#5

帖子 cxczqfrx » 2007-07-13 16:06

postgresql 的数据库安装后,还需要创建数据库和用户,才能使用
cxczqfrx
帖子: 107
注册时间: 2007-07-11 11:10
送出感谢: 0
接收感谢: 0

#6

帖子 cxczqfrx » 2007-07-13 16:09

安装后

sudo -u postgres createuser -P 用户名

按提示输入


sudo -u postgres createdb 数据库名

如果这两步完成的话,数据库就可以使用了
头像
百草谷居士
帖子: 2986
注册时间: 2006-02-10 16:36
系统: ubuntu18.04/Win10
送出感谢: 18 次
接收感谢: 32 次
联系:

Re: 装postgres数据库出问题!

#7

帖子 百草谷居士 » 2008-12-02 4:33

我看到不少人总是说在建立一个postgresql用户后要建立一个同名的数据库,请问建立一个和用户同名的数据库作用是什么?必须吗?
友帮拓,真难听。有没有接触官方的老大?给改了吧!
一直想找一个在linux下的Visual FoxPro/access桌面数据库。MUIBase还算是最相近的。
回复

回到 “数据库管理”