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