Skip site navigation (1) Skip section navigation (2)

Re: Connections and threading problems

From: Richard Huxton <dev(at)archonet(dot)com>
To: "Stergios Zissakis" <szis(at)intranet(dot)gr>,<pgsql-odbc(at)postgresql(dot)org>
Cc: "Kostas Lykiardopoulos" <klyk(at)intranet(dot)gr>,"Dimitris Pantermalis" <dpant(at)intranet(dot)gr>
Subject: Re: Connections and threading problems
Date: 2004-03-10 12:38:11
Message-ID: 200403101238.11593.dev@archonet.com (view raw or flat)
Thread:
Lists: pgsql-odbc
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

In response to

pgsql-odbc by date

Next:From: AndreasDate: 2004-03-10 15:39:16
Subject: Re: MS-Access connection with oracle via odbc loses connection
Previous:From: Richard HuxtonDate: 2004-03-10 12:31:06
Subject: Re: Win98 client connection problem (was THANK YOU)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group