PHP/Postgres/Solaris problem

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: Raw Message | Whole Thread | 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

Browse pgsql-admin by date

  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.