pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Very Urgent : Db processes are increasing 2+ messages / 2 participants [nested] [flat]
* Very Urgent : Db processes are increasing @ 2008-07-17 09:16 Suresh Gupta VG <suresh.g@zensar.com> 2008-07-17 13:38 ` Re: Very Urgent : Db processes are increasing Andrew Sullivan <ajs@commandprompt.com> 0 siblings, 1 reply; 2+ messages in thread From: Suresh Gupta VG @ 2008-07-17 09:16 UTC (permalink / raw) To: pgsql-admin Hi List, I am using pgsql 7.4.2 on solaris-9. When I start the postgres with "-i" option as below, the processes of the postgres are increasing drastically. pg_ctl start -D /db1/postgresql/data -o "-i" If I exclude "-I" option, my application couldn't connect the DB server at all. Here are my queries. 1) Why DB processes are increasing drastically, it reaches up to 104 connection( configured to 100 max connections) through there is no application trying to connect/access the DB. 2) Is "-I" option is important to get the access from other server to DB server ?? Pls reply your quick response. --Suresh DISCLAIMER: This email may contain confidential or privileged information for the intended recipient(s) and the views expressed in the same are not necessarily the views of Zensar Technologies Ltd. If you are not the intended recipient or have received this e-mail by error, its use is strictly prohibited, please delete the e-mail and notify the sender. Zensar Technologies Ltd. does not accept any liability for virus infected mails. ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Very Urgent : Db processes are increasing 2008-07-17 09:16 Very Urgent : Db processes are increasing Suresh Gupta VG <suresh.g@zensar.com> @ 2008-07-17 13:38 ` Andrew Sullivan <ajs@commandprompt.com> 0 siblings, 0 replies; 2+ messages in thread From: Andrew Sullivan @ 2008-07-17 13:38 UTC (permalink / raw) To: pgsql-admin On Thu, Jul 17, 2008 at 02:46:58PM +0530, Suresh Gupta VG wrote: > Hi List, > > I am using pgsql 7.4.2 on solaris-9. Go and upgrade that right away. It has several very nasty bugs in it. 7.4.21 is the latest. > pg_ctl start -D /db1/postgresql/data -o "-i" > > If I exclude "-I" option, my application couldn't connect the DB server > at all. Well, you could set that in the configuration file, but obviously, you're using the network somehow. > Here are my queries. > 1) Why DB processes are increasing drastically, it reaches up to 104 > connection( configured to 100 max connections) through there is no > application trying to connect/access the DB. Something is connecting. You can change the logging settings to find out who is connecting and from where. Alternatively, try netstat to look at who is connecting to port 5432. > 2) Is "-I" option is important to get the access from other server to DB > server ?? Well, it's spelled "-i", but yes. You have to listen on a TCP/IP socket, or else nobody can connect from another server. A -- Andrew Sullivan ajs@commandprompt.com +1 503 667 4564 x104 http://www.commandprompt.com/ ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-07-17 13:38 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2008-07-17 09:16 Very Urgent : Db processes are increasing Suresh Gupta VG <suresh.g@zensar.com> 2008-07-17 13:38 ` Andrew Sullivan <ajs@commandprompt.com>
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