FW: small problem with RA to PSQL.
От | Geoff |
---|---|
Тема | FW: small problem with RA to PSQL. |
Дата | |
Msg-id | FDCF842C8B1DD311833C0090277C04B50C94CC@augusta.planmatics.co.uk обсуждение исходный текст |
Список | pgadmin-support |
Hi, I've just installed Postgres 7.2 ( I thought .1 but not according to the PG_VERSION file :o( ) into my user area on a linux node ( Running Debian ). Everything is fine, the database is accessable via the cmd line.The database user is "geoff" as is my linux user in this case... The database is running on port 8061. geoff@mail:~/site_root/psql/data$ psql template1 Welcome to psql, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help on internal slash commands \g or terminate with semicolon to execute query \q to quit template1=# ok, now my trouble is I just can't seem to access it through pgAdminII on my windows client... I've read the docs and archives and found this to be a common gotcha so I've read them carefully I think and made the following changes as directed.. in pg_hba.conf I've added this line: "host all 194.201.29.0 255.255.255.0 trust " since my ip addess internally is 194.201.29.175 but I need another windows client to access the database too on a different IP addess. In postgresql.conf I've uncommented the following lines : tcpip_socket=1 port = 8061 .... here's the error I still get though : An error has occured in PGAdminII:frmConnect.cmdConnect_Click: Number: -2147217843 Description: FATAL 1: No pg_hba.conf entry for host 194.201.29.175, user geoff, database template1 Is there anything else that I need to do to get me up and running... TIA Geoff
В списке pgadmin-support по дате отправления: