Thread: 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
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.
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 > >
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/
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?
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/