Cannot make connection to postgresql 7.4 on FreeBSD

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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Re: Cannot make connection to postgresql 7.4 on FreeBSD

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

Re: Cannot make connection to postgresql 7.4 on FreeBSD

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


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Re: Cannot make connection to postgresql 7.4 on FreeBSD

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/

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Re: Cannot make connection to postgresql 7.4 on FreeBSD

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?

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Re: Cannot make connection to postgresql 7.4 on FreeBSD

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/

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly