pg.ddx.io pgsql-php@postgresql.org mailing list archive
help / color / mirror / Atom feedCannot 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