pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Cannot make connection to postgresql 7.4 on FreeBSD
6+ messages / 3 participants
[nested] [flat]

* Cannot make connection to postgresql 7.4 on FreeBSD
@ 2006-06-26 02:28  arie nugraha <dicarve@gmail.com>
  0 siblings, 1 reply; 6+ messages in thread

From: arie nugraha @ 2006-06-26 02:28 UTC (permalink / raw)
  To: pgsql-php

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?

Thanks



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Cannot make connection to postgresql 7.4 on FreeBSD
@ 2006-06-27 01:02  ljb <ljb220@mindspring.com>
  parent: arie nugraha <dicarve@gmail.com>
  0 siblings, 1 reply; 6+ messages in thread

From: ljb @ 2006-06-27 01:02 UTC (permalink / raw)
  To: pgsql-php

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.



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Cannot make connection to postgresql 7.4 on FreeBSD
@ 2006-06-27 03:40  arie nugraha <dicarve@gmail.com>
  parent: ljb <ljb220@mindspring.com>
  0 siblings, 1 reply; 6+ messages in thread

From: arie nugraha @ 2006-06-27 03:40 UTC (permalink / raw)
  To: pgsql-php

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
>
>   




^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Cannot make connection to postgresql 7.4 on FreeBSD
@ 2006-06-27 03:54  Chris <dmagick@gmail.com>
  parent: arie nugraha <dicarve@gmail.com>
  0 siblings, 1 reply; 6+ messages in thread

From: Chris @ 2006-06-27 03:54 UTC (permalink / raw)
  To: arie nugraha <dicarve@gmail.com>; +Cc: pgsql-php

arie nugraha wrote:
> 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.

Can you through the command line?

psql -d ...

That will at least tell us if it's a postgresql issue or a php issue.

-- 
Postgresql & php tutorials
http://www.designmagick.com/



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Cannot make connection to postgresql 7.4 on FreeBSD
@ 2006-06-27 06:02  arie nugraha <dicarve@gmail.com>
  parent: Chris <dmagick@gmail.com>
  0 siblings, 1 reply; 6+ messages in thread

From: arie nugraha @ 2006-06-27 06:02 UTC (permalink / raw)
  To: pgsql-php

Yes i can, psql run smoothly without any problem and can connect to all 
databases i have created.
Or maybe i should re-compile php and statically add pgsql support inside it?



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Cannot make connection to postgresql 7.4 on FreeBSD
@ 2006-06-27 06:31  Chris <dmagick@gmail.com>
  parent: arie nugraha <dicarve@gmail.com>
  0 siblings, 0 replies; 6+ messages in thread

From: Chris @ 2006-06-27 06:31 UTC (permalink / raw)
  To: arie nugraha <dicarve@gmail.com>; +Cc: pgsql-php

arie nugraha wrote:
> Yes i can, psql run smoothly without any problem and can connect to all 
> databases i have created.

Are you doing that as a superuser (like 'postgres') or a regular user 
you have created?

You might be using the "superuser_reserved_connections" if you're 
connecting as a superuser.

 > Or maybe i should re-compile php and statically add pgsql support inside
 > it?

That won't make any difference I don't think.

-- 
Postgresql & php tutorials
http://www.designmagick.com/



^ permalink  raw  reply  [nested|flat] 6+ messages in thread


end of thread, other threads:[~2006-06-27 06:31 UTC | newest]

Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-06-26 02:28 Cannot make connection to postgresql 7.4 on FreeBSD arie nugraha <dicarve@gmail.com>
2006-06-27 01:02 ` ljb <ljb220@mindspring.com>
2006-06-27 03:40   ` arie nugraha <dicarve@gmail.com>
2006-06-27 03:54     ` Chris <dmagick@gmail.com>
2006-06-27 06:02       ` arie nugraha <dicarve@gmail.com>
2006-06-27 06:31         ` Chris <dmagick@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox