Re: No connection to a PG 8.0 Beta 1 win32 server
От | Secrétariat |
---|---|
Тема | Re: No connection to a PG 8.0 Beta 1 win32 server |
Дата | |
Msg-id | 000c01c489c5$47046710$0a00a8c0@lrp43008 обсуждение исходный текст |
Ответы |
Re: No connection to a PG 8.0 Beta 1 win32 server
|
Список | pgsql-general |
Hello ! I've corrected my win32 pg_hba.conf, it contains : host all all 127.0.0.1 255.255.255.255 md5 host all all 192.168.0.0 255.255.255.0 md5 but I can't connect from my W2k client at IP 192.168.0.11 ! My postgresql.conf contains : #--------------------------------------------------------------------------- # CONNECTIONS AND AUTHENTICATION #--------------------------------------------------------------------------- # - Connection Settings - #listen_addresses = 'localhost' # what IP interface(s) to listen on; # defaults to localhost, '*' = any tcpip_socket = true port = 5432 max_connections = 100 # note: increasing max_connections costs about 500 bytes of shared # memory per connection slot, in addition to costs from shared_buffers # and max_locks_per_transaction superuser_reserved_connections = 2 #unix_socket_directory = '' #unix_socket_group = '' #unix_socket_permissions = 0777 # octal #rendezvous_name = '' # defaults to the computer name # - Security & Authentication - #authentication_timeout = 60 # 1-600, in seconds #ssl = false #password_encryption = true #krb_server_keyfile = '' #db_user_namespace = false I create (in bin) the script reload.bat to reload the service : @echo. @C:\WINDOWS\system32\net.exe stop pgsql-8.0-beta1 @echo. @C:\WINDOWS\system32\net.exe start pgsql-8.0-beta1 pause With "tcpip_socket = true" the script reload.bat stop the service but can't start !? So I can't connect from the W2k client ... With "#tcpip_socket = true" the script reload.bat stop and start the service. But can't connect from the W2k client . I define NT user variables : PGDATA=C:\Program Files\PostgreSQL\8.0-beta1\data PGPORT=5432 No change. I don't understand what happen ... Luc
В списке pgsql-general по дате отправления: