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

Re: psql: FATAL: sorry, too many clients already

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: luis muro <luis(dot)muro(at)gmail(dot)com>
Cc: Fernando Hevia <fhevia(at)ip-tel(dot)com(dot)ar>, pgsql-es-ayuda(at)postgresql(dot)org
Subject: Re: psql: FATAL: sorry, too many clients already
Date: 2009-11-17 13:30:34
Message-ID: 20091117133034.GA4146@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-es-ayuda
luis muro escribió:
> Alvaro,
> 
> Encontre el problema uso gentoo y revisaba el directorio de trabajo y
> en /etc/conf.d/postgresql  el los archivos que modificaba eran los correctos
> PGDATA="/var/lib/postgresql/data"

Pff, podrías haber dicho antes que era Gentoo.  Yo te habría respondido
de inmediato que esa plataforma tiene toda clases de insanidades, como
esta:

> # Extra options to run postmaster with
> # -N is the maximal number of client connections
> # -B is the number of shared buffers and has to be at least 2x the value for
> -N
> # Please read the man-page to postmaster for more options. Many of these
> options
> # can be set directly in the configuration-file.
> PGOPTS="-N 40 -B 80"

Setear opciones a postmaster es la idea mas imbécil que alguna distro ha
ocupado jamás para configurar postgres (aunque seguida muy de cerca por
redirigir la salida de postmaster a /dev/null).

-- 
Alvaro Herrera       Vendo parcela en Valdivia:  http://rie.cl/?a=255568
"In a specialized industrial society, it would be a disaster
to have kids running around loose." (Paul Graham)

In response to

pgsql-es-ayuda by date

Next:From: Fernando HeviaDate: 2009-11-17 14:21:46
Subject: RE: psql: FATAL: sorry, too many clients already
Previous:From: luis muroDate: 2009-11-17 03:20:13
Subject: Re: psql: FATAL: sorry, too many clients already

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