Re: [phplib] phplib / pgsql 7 problems (too many clients) From: Arno A. Karner (karner <email protected>)
Date: 10/28/00

increasing the number of simultaneous connections of postgres, decrease
the number of apache clients, make sure if your using pg_commands to to
always close data base connections

POSTMASTER(1) POSTMASTER(1)

NAME
       postmaster - Run the Postgres multi-user backend

SYNOPSIS
       postmaster [ -B nBuffers ] [ -D DataDir ] [ -N maxBackends ] [ -S
]
           [ -d DebugLevel ] [ -i ] [ -l ]
           [ -o BackendOptions ] [ -p port ] [ -n | -s ]

   INPUTS
       postmaster accepts the following command line arguments:

       -B nBuffers
              Sets the number of shared-memory disk buffers for
              the postmaster to allocate for use by the backend
              server processes that it starts. This value
              defaults to 64 buffers, where each buffer is 8k
              bytes (or whatever BLCKSZ is set to in
              src/include/config.h).

       -D DataDir
              Specifies the directory to use as the root of the
              tree of database directories. If -D is not given,
              the default data directory name is the value of the
              environment variable PGDATA. If PGDATA is not set,
              then the directory used is $POSTGRESHOME/data. If
              neither environment variable is set and this com­
              mand-line option is not specified, the default
              directory that was set at compile-time is used.

       -N maxBackends
              Sets the maximum number of backend server processes
              that this postmaster is allowed to start. By
              default, this value is 32, but it can be set as
              high as 1024 if your system will support that many
              processes. (Note that -B is required to be at
              least twice -N, so you'll need to increase -B if
              you increase -N.) Both the default and upper limit
              values for -N can be altered when building Postgres
              (see src/include/config.h).

       -S Specifies that the postmaster process should start
              up in silent mode. That is, it will disassociate
              from the user's (controlling) tty, start its own
              process group, and redirect its standard output and
              standard error to /dev/null.

              Note that using this switch makes it very difficult
              to troubleshoot problems, since all tracing and
              logging output that would normally be generated by
              this postmaster and its child backends will be dis­
              carded.

       -d DebugLevel
              Determines the amount of debugging output the back­
              end servers will produce. If DebugLevel is one,
              the postmaster will trace all connection traffic.
              Levels two and higher turn on increasing amounts of
              debug output from the backend processes, and the
              postmaster displays more information including the
              backend environment and process traffic. Note that
              unless the postmaster's standard output and stan­
              dard error are redirected into a log file, all this
              output will appear on the controlling tty of the
              postmaster.

       -i Allows clients to connect via TCP/IP (Internet
              domain) connections. Without this option, only
:

Pascal Jolin wrote:
>
> I've recently started getting the following error using pgsql 7 with phplib:
>
> Warning: Unable to connect to PostgresSQL server: Sorry, too many clients
> already in /usr/local/lib/php/phplib-7.2/php/db_pgsql.inc on line 40
> Database error: Link-ID == false, pconnect failed
> PostgreSQL Error: 0 ()
> Session halted.
>
> I've been unable to isolate the source of the problem, and when I get this
> error I'm still able to open a connection to the database using the psql
> utility.
>
> Can anyone give me a pointer on this ?
>
> Perhaps I need to increase the number of simultaneous connections allowed to
> pgsql ? (If so, I'd appreciate help there too, as the postgresql
> documentation wasn't clear on this).
>
> Thank you.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: phplib-unsubscribe <email protected>
> For additional commands, e-mail: phplib-help <email protected> 

-- 
My opinions are my own and not that of my employer even if I am self
employed
Tech Net, Inc.            --FREE THE MACHINES--                 
651.224.2223
627 Palace Ave. #2           karner <email protected>              
karner <email protected>
St. Paul, MN 55102-3517        www.tnss.com         
wanted    : adsl/cable modem with static ip at reasonable price
accept-txt: us-ascii,html,pdf
accept-dat: ascii-delimited,sql insert statments

---------------------------------------------------------------------
To unsubscribe, e-mail: phplib-unsubscribe <email protected>
For additional commands, e-mail: phplib-help <email protected>