| From: | superedo(dot)geoNOSPAM(at)yahoo(dot)com |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | PHP/Postgres/Solaris problem |
| Date: | 2001-04-11 17:14:24 |
| Message-ID: | 9b23dg$n2e$1@news.netmar.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hello,
We have a Sparc w/Solaris8 equipped with Apache1.3.14 + PostgreSQL 7.0.3 +
PHP4
We manage a 60 MB database with 30 tables and 70000 records, accessing it
via
php. We have the following problems:
1) Sometimes the connection to the Postgres backend unexpectly fails with the
following message:
Warning: Unable to connect to PostgreSQL server: Backend startup failed in
/usr/libr/start.inc on line 25
Refreshing the page often solve the problem and the php connects to the db.
2) We note a big(suspect) slowdown in performance (we previously had a Mysql
DB). Often we note a big delay in the loading of the
pages.
3) We note a suspect number of postgres backend processes running in the
background, even if there is no query actually running (and
we don't use pconnect).
Thank you
Mike
----- Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web -----
http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups
NewsOne.Net prohibits users from posting spam. If this or other posts
made through NewsOne.Net violate posting guidelines, email abuse(at)newsone(dot)net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jozef KRSSAK | 2001-04-12 00:52:38 | pg_hba.conf and ident authentification |
| Previous Message | Peter Galbavy | 2001-04-11 09:15:40 | Re: Encryption. |