不知道postgresql 8.0.1怎么没有initdb这个程序

guyon

系统为Debian，直接用它的deb来安装。

还有就是pgadmin在7.4的时候又连不上
pg_hda.conf pg_ident.conf都是用默认的
好像默认是打开了本地认证用户

# cat /var/log/postgres/postgres.log
2005-04-03 10:40:42 [9014] LOG:  connection received: host=127.0.0.1 port=32999
2005-04-03 10:40:42 [9014] LOG:  could not connect to Ident server at address "127.0.0.1", port 113: Connection refused
2005-04-03 10:40:42 [9014] FATAL:  IDENT authentication failed for user "ee"
2005-04-03 10:40:42 [9015] LOG:  connection received: host=127.0.0.1 port=33001
2005-04-03 10:40:42 [9015] LOG:  could not connect to Ident server at address "127.0.0.1", port 113: Connection refused
2005-04-03 10:40:42 [9015] FATAL:  IDENT authentication failed for user "ee"

$ cat ~/pgadmin.log
2005-04-03 10:40:42 ERROR  : Error connecting to the server: FATAL:  IDENT authentication failed for user "ee"

$ cat ~/.pgadmin3
NextTipOfTheDay=10
LastDatabase=template1
LastPort=5432
LastSSL=0
LastUsername=ee
LogFile=pgadmin.log
LogLevel=1
AskSaveConfirmation=true
ConfirmDelete=true
ShowUsersForPrivileges=false
SqlHelpSite=
Proxy=
AutoRowCount=2000
WriteUnicodeFile=0
SearchPath=
MaxServerLogSize=100000
Font=
ShowTipOfTheDay=1
StickySql=0
DoubleClickProperties=1
LanguageId=0
[Properties]
[Properties/Server]
Left=424
Top=309
[Servers]
Count=0
[frmMain]
Left=260
Top=189
Width=750
Height=550
SplitHorizontal=300
SplitVertical=200
[frmQuery]
MaxRows=100
MaxColSize=256
ExplainVerbose=0
ExplainAnalyze=0
Font=monospace 12
[Export]
Unicode=false
QuoteChar="\""
ColSeparator=;
RowSeparator=LF
Quote=Strings
ShowTipOfTheDay=1

黄叶

当然有initdb这个程序了。

黄叶

修改配制文件，不能使用默认的。
修改配置文件使得可以接受TCP/IP连接，并更改它的认证方式 。

guyon

多谢版主，不过真的比较郁闷
重新装回8.0的
postgres@BKU:~$ initdb
-su: initdb: command not found
后来发现postmaster也没有了，可能是系统的问题 -_-

看来还是要去找源码编译才行

guyon

发现一个问题，在7.4中有initdb和postmaster，而在Debian里面有改动
If you are installing a pre-packaged distribution, such as an RPM or Debian package, ignore this chapter and read the packager's instructions instead

Debian里面的
postgresql-8.0 (8.0.1-2) experimental; urgency=low

  * Changed dependency of pg-pltcl-8.0 from libtcl8.4 to tcl8.4
  * Now depend on postgresql-common >= 3 which provides more maintainer script
    functions.

想问一下postgresql-common的用法
manager for PostgreSQL database clusters
postgresql-common provides a structure under which multiple versions of
PostgreSQL may be installed and/or multiple clusters maintained at one
time.

victoryu

请问如何修改配置才能进行tcp-ip连接，能否详细点，谢。