pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Bruno Wolff III <bruno@wolff.to>
To: Pradeepkumar, Pyatalo (IE10) <Pradeepkumar.Pyatalo@honeywell.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: problem with setting PATH variable
Date: Fri, 20 Aug 2004 09:15:55 -0500
Message-ID: <20040820141555.GA22875@wolff.to> (raw)
In-Reply-To: <77ED2BF75D59D1439F90412CC5B10974108FD3E4@ie10-sahara.hiso.honeywell.com>
References: <77ED2BF75D59D1439F90412CC5B10974108FD3E4@ie10-sahara.hiso.honeywell.com>

On Fri, Aug 20, 2004 at 06:44:27 -0700,
  "Pradeepkumar, Pyatalo (IE10)" <Pradeepkumar.Pyatalo@honeywell.com> wrote:
> 
> 
> I am sorry for the confusion. One machine, I am running Red Hat Linux - 8.0
> with kernel version 2.4.18.
> Other machines have Red Hat Linux - 7.2 with kernel version 2.4.7
> Hope this is what you are expecting.

Yes.

> I am a newbie to postgresql and Linux, i have no idea about
> .bashrc,.cshrc,.profile.

You are going to want to read documentation on whatever shell you are
using, so as to learn how to configure things to help you work more
efficiently.

If you installed postgres by bulding from a source tar ball, most likely
stuff you want to use without typing the full path got put in /usr/local/bin.
If you install from an rpm, the binaries will normally get put in /usr/bin,
which should be in your path.

> I dont know where the logfile is, i havent checked it. Only thing is in the
> link they have given steps to run postmaster automatically on boot. After
> doing that, it doesnt automatically start after restart....we have to start
> it manually. There is no problem in starting it manually.

This sounds like you may not have told init that postgres is supposed to
be started in your default run level. You probably want to read
'man chkconfig' and then use chkconfig to set things so that postgres
is started by default. I think you will want to run something like:
chkconfig --levels 2345 postgresql on
You will need to do that as root.
> 
> In between i noticed some strange thing....
> when I run my application....it is creating a number of postmaster services,
> it was not happening before.
> when say 
> $ps -el 
> there are more than 10 postmaster services running
> 
> Then i get the error message - 
> FATAL : sorry too many client connections and other error
> LOG : unexpected EOF on client connection
> 
> any inputs on that.

A separate copy of the postmaster gets started for each database connection.
So if your webserver is connecting to your database, having multiple
postmaster processes is expected.

You probably want to set postgres' limit on the number of connections to
be slightly higher than the number of allowed connections to your web
server. A limit of only 10 postmaster processes is likely less than what
your web server is limited to and may be the source of your problem.



view thread (6+ messages)  latest in thread

Message-ID: <20040820141555.GA22875@wolff.to>
Permalink:  ../20040820141555.GA22875@wolff.to/
Also on:    postgresql.org/message-id/20040820141555.GA22875@wolff.to

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: bruno@wolff.to, Pradeepkumar.Pyatalo@honeywell.com
  Subject: Re: problem with setting PATH variable
  In-Reply-To: <20040820141555.GA22875@wolff.to>
  References: <77ED2BF75D59D1439F90412CC5B10974108FD3E4@ie10-sahara.hiso.honeywell.com> <20040820141555.GA22875@wolff.to>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox