PHP/PGSQL error after rebooting - Mailing list pgsql-novice

From Jacques Capesius
Subject PHP/PGSQL error after rebooting
Date
Msg-id CBDAD1D1-73DB-11D8-9A1C-000A95AB9C24@capesius.com
Whole thread Raw
List pgsql-novice
<fontfamily><param>Times</param><bigger><bigger>Hi guys,


to make a long story short, I had to reboot the webserver and after
much toiling, got apache up and running again, but suddenly, pages
that access the database were either returning no records, or giving
me the below error:<bold>


Warning</bold>: pg_connect(): Cannot create new link. Too many open
links (0). in <bold>....

</bold>the php function throwing the error is pg_connect($conn_string);<bold>

</bold>

I checked some other threads and there was mention of removing
extension=pgsql.so from the php.ini file. Did that and it didn't seem
to help. I running ./postgressql restart from the command line and
that didn't seem to help either.


Does anybody know what I need to do? Would running something like
./postgressql force-reload help? I'm afraid to run that command
because I don't know exactly what it does.


Thanks in advance for any help any of you can offer.


-jacques :-)</bigger></bigger></fontfamily>
Hi guys,

to make a long story short, I had to reboot the webserver and after
much toiling, got apache up and running again, but suddenly, pages that
access the database were either returning no records, or giving me the
below error:

Warning: pg_connect(): Cannot create new link. Too many open links (0).
in ....
the php function throwing the error is pg_connect($conn_string);

I checked some other threads and there was mention of removing
extension=pgsql.so from the php.ini file. Did that and it didn't seem
to help. I running ./postgressql restart from the command line and that
didn't seem to help either.

Does anybody know what I need to do? Would running something like
./postgressql force-reload help? I'm afraid to run that command because
I don't know exactly what it does.

Thanks in advance for any help any of you can offer.

-jacques :-)

pgsql-novice by date:

Previous
From: "Hari Bhanujan"
Date:
Subject: Startup script
Next
From: Tom Lane
Date:
Subject: Re: PostgreSQL 7.2.1 on OS X -- psql: FATAL 1: user "postgres" does not exist