Re: Connections and threading problems

On Thursday 04 March 2004 12:39, Stergios Zissakis wrote:
> Hi there,
>
> I have set up PGSQL 7.4 and unixODBC-2.2.8 on Solaris 8 (with the 113261-02
> patch applied).
> I'm using OTL 4 and a multi-threaded test program.
> I encountered the following problems.
> 1) I cannot get more than 5 threads to connect to the databse at the same
> time.

Your log file says you've reached your maximum number of connections.

2004-03-04 14:24:09 LOG:  connection authorized: user=szis database=test
2004-03-04 14:24:09 FATAL:  sorry, too many clients already

You'll want to increase max_connections in your postgresql.conf. Make sure PG
re-reads the file.

You also *do not* want to leave enable_seqscan set to false unless you are
testing.

--
  Richard Huxton
  Archonet Ltd