PHP/PGSQL error after rebooting

Поиск
Список
Период
Сортировка
От Jacques Capesius
Тема PHP/PGSQL error after rebooting
Дата
Msg-id CBDAD1D1-73DB-11D8-9A1C-000A95AB9C24@capesius.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: "Hari Bhanujan"
Дата:
Сообщение: Startup script
Следующее
От: Tom Lane
Дата:
Сообщение: Re: PostgreSQL 7.2.1 on OS X -- psql: FATAL 1: user "postgres" does not exist