Re: No connection to a PG 8.0 Beta 1 win32 server - Mailing list pgsql-general

From Secrétariat
Subject Re: No connection to a PG 8.0 Beta 1 win32 server
Date
Msg-id 000c01c489c5$47046710$0a00a8c0@lrp43008
Whole thread Raw
Responses Re: No connection to a PG 8.0 Beta 1 win32 server
List 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 by date:

Previous
From: Richard Huxton
Date:
Subject: Re: pg_dump in stand alone backend
Next
From: Daniel Martini
Date:
Subject: Re: pg_dump in stand alone backend