Thread: administering pgsql

administering pgsql

From
Felipe Schnack
Date:
  Anyone know a good starting guide to a pgsql administration? I created
a very simple database and I got an "too many connections" error. The
strange this is that the only person actually connected to it was an
phppgadmin and a tomcat dbcp pooling solution.

--

Felipe Schnack
Analista de Sistemas
felipes@ritterdosreis.br
Cel.: (51)91287530
Linux Counter #281893

Faculdade Ritter dos Reis
www.ritterdosreis.br
felipes@ritterdosreis.br
Fone/Fax.: (51)32303328


Re: administering pgsql

From
Dave Cramer
Date:
Felipe,

I'll bet money that you weren't releasing the connections back to the
pool?

Dave
On Thu, 2002-09-26 at 10:34, Felipe Schnack wrote:
>   Anyone know a good starting guide to a pgsql administration? I created
> a very simple database and I got an "too many connections" error. The
> strange this is that the only person actually connected to it was an
> phppgadmin and a tomcat dbcp pooling solution.
>
> --
>
> Felipe Schnack
> Analista de Sistemas
> felipes@ritterdosreis.br
> Cel.: (51)91287530
> Linux Counter #281893
>
> Faculdade Ritter dos Reis
> www.ritterdosreis.br
> felipes@ritterdosreis.br
> Fone/Fax.: (51)32303328
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>




Re: administering pgsql

From
João Paulo Ribeiro
Date:
Me too! ;)

JP
Dave Cramer wrote:

>Felipe,
>
>I'll bet money that you weren't releasing the connections back to the
>pool?
>
>Dave
>On Thu, 2002-09-26 at 10:34, Felipe Schnack wrote:
>
>
>>  Anyone know a good starting guide to a pgsql administration? I created
>>a very simple database and I got an "too many connections" error. The
>>strange this is that the only person actually connected to it was an
>>phppgadmin and a tomcat dbcp pooling solution.
>>
>>--
>>
>>Felipe Schnack
>>Analista de Sistemas
>>felipes@ritterdosreis.br
>>Cel.: (51)91287530
>>Linux Counter #281893
>>
>>Faculdade Ritter dos Reis
>>www.ritterdosreis.br
>>felipes@ritterdosreis.br
>>Fone/Fax.: (51)32303328
>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>>
>>
>>
>>
>
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to majordomo@postgresql.org so that your
>message can get through to the mailing list cleanly
>
>
>
>


--
----------------------------------------------------------------------------
MobiComp - Mobile Computing & Wireless Solutions
phone: +351 253 305 250     fax: +351 253 305 251
mobile: +351 96 8690226
web: http://www.mobicomp.com
----------------------------------------------------------------------------