nixCraft Linux Forum

nixCraft

Linux / UNIX Tech Support Forum

Postgres idle connections

This is a discussion on Postgres idle connections within the Databases servers forums, part of the Mastering Servers category; one of my server is sefering these messages on my postgresql server i think so many connections made by other ...


Go Back   nixCraft Linux Forum > Mastering Servers > Databases servers

Linux answers from nixCraft.


Databases servers Discussions of databases of all types - especially MySQL.

Reply

 

LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 11-05-2007, 04:34 PM
kasimani's Avatar
Senior Member
User
 
Join Date: Jul 2006
Location: India, Delhi
OS: CentOS, RedHat, Fedora, Ubuntu
Posts: 151
Thanks: 3
Thanked 1 Time in 1 Post
Rep Power: 4
kasimani is on a distinguished road
Send a message via Yahoo to kasimani
Default Postgres idle connections

one of my server is sefering these messages on my postgresql server
i think so many connections made by other servers running apache and not closing connections.

is there any way to kill idle connections


postgres 25343 0.0 0.0 443840 3428 pts/2 R 16:20 0:00 postgres: cmsuser cms <ipaddress>(5497 idle

postgres 25329 0.0 0.0 443580 2008 pts/2 R 16:20 0:00 postgres: cmsuser cms <ipaddress>(53900) idle
Reply With Quote
  #2 (permalink)  
Old 14-05-2007, 05:58 PM
rockdalinux's Avatar
Is that all you got?
User
 
Join Date: May 2005
Location: Planet Vegeta
OS: Redhat
Posts: 703
Thanks: 15
Thanked 19 Times in 18 Posts
Rep Power: 10
rockdalinux is a glorious beacon of light rockdalinux is a glorious beacon of light rockdalinux is a glorious beacon of light rockdalinux is a glorious beacon of light rockdalinux is a glorious beacon of light rockdalinux is a glorious beacon of light
Default

The default time out is okay for most cases if you need to change time out you need to edit database config and may linux networking config also.
__________________
Rocky Jr.
What's wrong? I hope I am not making you uncomfortable...

Never send a boy to do a mans job.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads

Thread Thread Starter Forum Replies Last Post
Combine 2 Airtel 512kbps broadband connections to get more bandwidth anharikrishna Linux software 1 26-07-2007 05:09 PM
Restrict number of simultaneous proxy connections in SQUID proxy pkvmreddy Getting started tutorials 1 15-06-2007 03:52 PM
Postgres vacuumdb usage kasimani Databases servers 2 06-03-2007 07:30 AM
Postgres backup chiku Databases servers 2 03-01-2007 09:43 PM


All times are GMT +5.5. The time now is 02:13 PM.


Powered by vBulletin® Version 3.8.5 - Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.3.2
©2005-2010 nixCraft. All rights reserved

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38