X-Original-To: pgsql-php-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 962EF9FA2F7 for ; Tue, 27 Jun 2006 00:42:24 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 90988-08 for ; Tue, 27 Jun 2006 00:42:14 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from venus.sip.co.id (unknown [202.155.61.80]) by postgresql.org (Postfix) with SMTP id 04C439FA5FC for ; Tue, 27 Jun 2006 00:42:13 -0300 (ADT) Received: (qmail 80541 invoked by uid 1009); 27 Jun 2006 03:48:16 -0000 Received: from 202-127-109-230.triplegate.net.id (HELO ?10.0.0.23?) (202.127.109.230) by venus.sip.co.id with SMTP; 27 Jun 2006 03:48:16 -0000 Message-ID: <44A0A8C9.5000103@gmail.com> Date: Tue, 27 Jun 2006 10:40:57 +0700 From: arie nugraha User-Agent: Thunderbird 1.5.0.4 (Windows/20060516) MIME-Version: 1.0 To: pgsql-php@postgresql.org Subject: Re: Cannot make connection to postgresql 7.4 on FreeBSD References: <449F464F.1070005@gmail.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/23 X-Sequence-Number: 3548 Im currently using PHP 4.4.2 (compile it by myself, not by FreeBSD ports), and then i compile the pgsql dynamic library (pgsql.so) with phpize. I already saw that my postgresql support is already enabled in phpinfo(), but i still can't connect it. > dicarve@gmail.com wrote: > >> Hi list, >> >> Last week, i compile postgresql 7.4 on my FreeBSD OS, and i planned to >> use it with php. >> I manage to run the postmaster, and i already saw it running in >> background with ps ax >> But when i try to connect with my php script i got an error which is >> look like this : >> >> *Cannot create link. Too many connection open....* >> >> I already enable the tcp/ip for my postmaster, but it seems doesn't >> change the situation >> >> Anyone can help me out? >> > > I've heard of this "too many connections" message before, and the cause was > always a messed-up installation. Some things to check: > + pgsql extension is either compiled into PHP or loaded as an extension, > but not both. > + pgsql extension (or PHP itself, if pgsql is built-in) is using or > referencing the version of PostgreSQL's libpq that you think it should be, > and not some other version. > If this doesn't help, post more details: PHP version, self-built or not, > relevant part from phpinfo() for PostgreSQL. > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org > >