Hello!

I'm new in the forum and I'm looking for help.

I'm working on an intranet, using Postgre 8.0, Windows 2000 and ASP. Lots of people uses this intranet and from time to time the connection limit (100 connections opened at the same time) exceeds.

After some tests I realized that when the code says 'connection.close' and 'set connection = nothing', the connection dont close imediatly. It takes more then 30 seconds for it to close, what gives time to the users to natigate em open more connections.

Anybody using postgre had the same problem? Any help will be apreciated.

Anybody knows if theres a fixed amount of memory the postgre is allowed to use. If so, is it possible to raise this amount?

You may well need to edit you pg_hba.conf file to allow connections.

Postgres comes boxed to run fine from the loacl computer, but once you start making web requests etc it is going to need some extra config.

FIND and edit pg_hba.conf

Find the part that starts with
# TYPE DATABASE USER CIDR-ADDRESS METHOD

and replace all under it with the following.

host all all 127.0.0.1 255.255.255.255 trust
# "local" is for Unix domain socket connections only
local all all ident sameuser

The local one is already present and allows connection from the box itself. host all ***** allows connections from the loopback (which facilitates web hits) (providing the web server is on this box).

To allow remote connections add an ip range (same format as the hosts file) then edit

FIND and edit postgresql.conf
uncommenct out the port line so you can accept foreign connections.

restart postgres
Try it out

psql -U <user> -h <host> -W <dbname>

Ibbo