- 论坛徽章:
- 6
|
环境:
server:fedora 9
client: windows xp
database:
BINDIR = /usr/local/pgsql/bin
DOCDIR = /usr/local/pgsql/doc
INCLUDEDIR = /usr/local/pgsql/include
PKGINCLUDEDIR = /usr/local/pgsql/include
INCLUDEDIR-SERVER = /usr/local/pgsql/include/server
LIBDIR = /usr/local/pgsql/lib
PKGLIBDIR = /usr/local/pgsql/lib
LOCALEDIR =
MANDIR = /usr/local/pgsql/man
SHAREDIR = /usr/local/pgsql/share
SYSCONFDIR = /usr/local/pgsql/etc
PGXS = /usr/local/pgsql/lib/pgxs/src/makefiles/pgxs.mk
CONFIGURE =
CC = gcc
CPPFLAGS = -D_GNU_SOURCE
CFLAGS = -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv
CFLAGS_SL = -fpic
LDFLAGS = -Wl,-rpath,\'/usr/local/pgsql/lib\'
LDFLAGS_SL =
LIBS = -lpgport -lz -lreadline -lcrypt -ldl -lm
VERSION = PostgreSQL 8.3.1
我在新安装的数据库上,以postgres默认用户运行了createuser命令,创建了一个postgres数据库用户叫postgrestest,并且给了superuser的权限。同时查看了一下/etc/passwd文件的内容,该文件中并未出现新增加用户的记录,说明只是添加了数据库用户,在pgadmin中也能看到。
但是当我用命令
-bash-3.2$ psql -U postgrestest -d bpsimple
psql: FATAL: Ident authentication failed for user \"postgrestest\"
请问还需要在哪里进行权限设置啊? 谢谢了! |
|