why does postmaster get down ??? - Mailing list pgsql-admin

From Dronamraju Rajesh
Subject why does postmaster get down ???
Date
Msg-id 20001117123602.41154.qmail@web9609.mail.yahoo.com
Whole thread Raw
List pgsql-admin
Hi there,

     I have mod-perl apache sending continous web
requests to postmaster. My system is a linux box with
dual CPU with 1GB RAM.

     I have started the postmaster with the following
command line:-

postmaster -i -N 256 -B 512
>>/usr/local/pgsql/server.log 2>&1 &

I have also tried with higher and low number of
postmasters and variating buffers also. But no use.

I am vacuuming my database every 4 hours else it is
serving the requests very slowly and getting down at
some point and my mod-perl apache shows the following
errors:-

============================================
DBD::Pg::db rollback failed: begin failed
DBD::Pg::db selectrow_array failed: pqReadData() --
backend closed the channel unexpectedly.
        This probably means the backend terminated
abnormally before or while processing the request.
DBD::Pg::db selectrow_array failed: pqReadData() --
backend closed the channel unexpectedly.
        This probably means the backend terminated
abnormally before or while processing the request.
DBD::Pg::db rollback failed: rollback failed
DBD::Pg::db selectrow_array failed: pqReadData() --
backend closed the channel unexpectedly.
        This probably means the backend terminated
abnormally before or while processing the request.
DBD::Pg::db rollback failed: rollback failed
DBD::Pg::db rollback failed: rollback failed
DBD::Pg::db rollback failed: begin failed
DBD::Pg::db rollback failed: begin failed
DBD::Pg::db rollback failed: begin failed
DBD::Pg::db rollback failed: begin failed
DBD::Pg::db rollback failed: begin failed
DBD::Pg::db rollback failed: begin failed
DBD::Pg::db rollback failed: begin failed
DBD::Pg::db selectrow_array failed: pqReadData() --
backend closed the channel unexpectedly.
DBI->connect failed: pqReadData() -- backend closed
the channel unexpectedly.
        This probably means the backend terminated
abnormally before or while processing the request. at
/usr/local/etc/httpd/sites/ad3.adcept.net/cgi-bin/adceptdelivery.cgi
line 785
DBI->connect failed: pqReadData() -- backend closed
the channel unexpectedly.
        This probably means the backend terminated
abnormally before or while processing the request.
 at
/usr/local/etc/httpd/sites/ad3.adcept.net/cgi-bin/adceptdelivery.cgi
line 785
DBI->connect failed: connectDB() -- connect() failed:
Connection refused
Is the postmaster running at 'localhost' and accepting
connections on Unix socket '5432'?at
/usr/local/etc/httpd/sites/ad3.adcept.net/cgi-bin/adceptdelivery.cgi
line 785
===================================================

how can i improve the performance of postmaster ? and
is there no other go otherthan to vacuum every 4
hours.

pl help me

Regards
Rajesh
tech solutions,
Intercept Consulting - INDIA.


__________________________________________________
Do You Yahoo!?
Yahoo! Calendar - Get organized for the holidays!
http://calendar.yahoo.com/

pgsql-admin by date:

Previous
From: kumar1@home.com (Prasanth A. Kumar)
Date:
Subject: Re: Tool for filling database
Next
From: "Timothy J Hitchens"
Date:
Subject: What security on database files