SAS Postgress servcies in idle and in transaction

[sathya66]

All,

Any idea why the postgres services are in idle and in transaction below. I applied the latest license ,hotfixes and restarted the sas services and  seen this idle message when I grep for sas(no impacts on users yet).

sas 12978 12169 0 Jan13 ? 01:27:49 postgres: SharedServices SharedServices 99.55.521.33(46132) idle
sas 12979 12169 0 Jan13 ? 00:02:53 postgres: SharedServices SharedServices 99.55.521.33(46134) idle
sas 12980 12169 0 Jan13 ? 00:00:40 postgres: SharedServices SharedServices 99.55.521.33(46136) idle
sas 12981 12169 0 Jan13 ? 00:00:12 postgres: SharedServices SharedServices 99.55.521.33(46138) idle
sas 12982 12169 0 Jan13 ? 00:00:03 postgres: SharedServices SharedServices 99.55.521.33(46140) idle
sas 12983 12169 0 Jan13 ? 00:00:00 postgres: SharedServices SharedServices 99.55.521.33(46142) idle
sas 12984 12169 0 Jan13 ? 00:00:00 postgres: SharedServices SharedServices 99.55.521.33(46144) idle
sas 12985 12169 0 Jan13 ? 00:00:00 postgres: SharedServices SharedServices 99.55.521.33(46146) idle
sas 12986 12169 0 Jan13 ? 00:00:00 postgres: SharedServices SharedServices 99.55.521.33(46148) idle
sas 13524 12261 0 Jan13 ? 00:00:00 postgres: TAServices TAServices 99.55.521.33(46948) idle
sas 13525 12261 0 Jan13 ? 00:00:00 postgres: TAServices TAServices 99.55.521.33(46950) idle
sas 13526 12261 0 Jan13 ? 00:00:00 postgres: TAServices TAServices 99.55.521.33(46952) idle
sas 13527 12261 0 Jan13 ? 00:00:00 postgres: TAServices TAServices 99.55.521.33(46954) idle
sas 13528 12261 0 Jan13 ? 00:00:00 postgres: TAServices TAServices 99.55.521.33(46956) idle
sas 13529 12261 0 Jan13 ? 00:00:00 postgres: TAServices TAServices 99.55.521.33(46958) idle
sas 13530 12261 0 Jan13 ? 00:00:00 postgres: TAServices TAServices 99.55.521.33(46960) idle
sas 13531 12261 0 Jan13 ? 00:00:00 postgres: TAServices TAServices 99.55.521.33(46962) idle
sas 13532 12261 0 Jan13 ? 00:00:00 postgres: TAServices TAServices 99.55.521.33(46964) idle
sas 13533 12261 0 Jan13 ? 00:00:00 postgres: TAServices TAServices 99.55.521.33(46966) idle
sas 13534 12301 0 Jan13 ? 00:00:00 postgres: dcmdb dcmdb 99.55.521.33(51488) idle
sas 13535 12301 0 Jan13 ? 00:00:00 postgres: dcmdb dcmdb 99.55.521.33(51490) idle
sas 13536 12301 0 Jan13 ? 00:00:00 postgres: dcmdb dcmdb 99.55.521.33(51492) idle
sas 13537 12301 0 Jan13 ? 00:00:00 postgres: dcmdb dcmdb 99.55.521.33(51494) idle
sas 13538 12301 0 Jan13 ? 00:00:00 postgres: dcmdb dcmdb 99.55.521.33(51496) idle
sas 13539 12301 0 Jan13 ? 00:00:00 postgres: dcmdb dcmdb 99.55.521.33(51498) idle
sas 13540 12301 0 Jan13 ? 00:00:00 postgres: dcmdb dcmdb 99.55.521.33(51500) idle
sas 13541 12301 0 Jan13 ? 00:00:00 postgres: dcmdb dcmdb 99.55.521.33(51502) idle
sas 13542 12301 0 Jan13 ? 00:00:00 postgres: dcmdb dcmdb 99.55.521.33(51504) idle
sas 13543 12301 0 Jan13 ? 00:00:00 postgres: dcmdb dcmdb 99.55.521.33(51506) idle
sas 13544 12169 0 Jan13 ? 00:21:21 postgres: SharedServices SharedServices 99.55.521.33(46844) idle
sas 13545 12169 0 Jan13 ? 00:00:14 postgres: SharedServices SharedServices 99.55.521.33(46846) idle
sas 13546 12169 0 Jan13 ? 00:00:02 postgres: SharedServices SharedServices 99.55.521.33(46848) idle
sas 13547 12169 0 Jan13 ? 00:00:00 postgres: SharedServices SharedServices 99.55.521.33(46850) idle
sas 13548 12169 0 Jan13 ? 00:00:00 posRtgres: SharedServices SharedServices 99.55.521.33(46852) idle
sas 13549 12169 0 Jan13 ? 00:00:00 postgres: SharedServices SharedServices 99.55.521.33(46854) idle
sas 13550 12169 0 Jan13 ? 00:00:00 postgres: SharedServices SharedServices 99.55.521.33(46856) idle
sas 13551 12169 0 Jan13 ? 00:00:00 postgres: SharedServices SharedServices 99.55.521.33(46858) idle
sas 13552 12169 0 Jan13 ? 00:00:00 postgres: SharedServices SharedServices 99.55.521.33(46860) idle
sas 13554 12169 0 Jan13 ? 00:00:00 postgres: SharedServices SharedServices 99.55.521.33(46862) idle
sas 14128 12393 0 Jan13 ? 00:01:17 postgres: fsmgradmin fsmgrdb 99.55.521.33(60710) idle
sas 14129 12393 0 Jan13 ? 00:00:00 postgres: fsmgradmin fsmgrdb 99.55.521.33(60712) idle
sas 14130 12393 0 Jan13 ? 00:00:00 postgres: fsmgradmin fsmgrdb 99.55.521.33(60714) idle
sas 14131 12393 0 Jan13 ? 00:00:00 postgres: fsmgradmin fsmgrdb 99.55.521.33(60716) idle
sas 14132 12393 0 Jan13 ? 00:00:00 postgres: fsmgradmin fsmgrdb 99.55.521.33(60718) idle
sas 14133 12393 0 Jan13 ? 00:00:00 postgres: fsmgradmin fsmgrdb 99.55.521.33(60720) idle
sas 14134 12393 0 Jan13 ? 00:00:00 postgres: fsmgradmin fsmgrdb 99.55.521.33(60722) idle
sas 14135 12393 0 Jan13 ? 00:00:00 postgres: fsmgradmin fsmgrdb 99.55.521.33(60724) idle
sas 14136 12393 0 Jan13 ? 00:00:00 postgres: fsmgradmin fsmgrdb 99.55.521.33(60726) idle
sas 14137 12393 0 Jan13 ? 00:00:00 postgres: fsmgradmin fsmgrdb 99.55.521.33(60728) idle
sas 14138 12331 0 Jan13 ? 00:00:00 postgres: rmdbuser DataRemediationDataServer 99.55.521.33(42252) idle
sas 14139 12331 0 Jan13 ? 00:00:00 postgres: rmdbuser DataRemediationDataServer 99.55.521.33(42254) idle
sas 14141 12331 0 Jan13 ? 00:00:00 postgres: rmdbuser DataRemediationDataServer 99.55.521.33(42256) idle
sas 14142 12331 0 Jan13 ? 00:00:00 postgres: rmdbuser DataRemediationDataServer 99.55.521.33(42258) idle
sas 14143 12331 0 Jan13 ? 00:00:00 postgres: rmdbuser DataRemediationDataServer 99.55.521.33(42260) idle
sas 14144 12331 0 Jan13 ? 00:00:00 postgres: rmdbuser DataRemediationDataServer 99.55.521.33(42262) idle
sas 14145 12331 0 Jan13 ? 00:00:00 postgres: rmdbuser DataRemediationDataServer 99.55.521.33(42264) idle
sas 14146 12331 0 Jan13 ? 00:00:00 postgres: rmdbuser DataRemediationDataServer 99.55.521.33(42266) idle

sas 14863 12169 0 Jan13 ? 00:00:00 postgres: EVManager EVManager 99.55.521.33(48536) idle in transaction
sas 14885 12169 0 Jan13 ? 00:00:00 postgres: EVManager EVManager 99.55.521.33(48558) idle
sas 14887 12169 0 Jan13 ? 00:00:00 postgres: EVManager EVManager 99.55.521.33(48560) idle
sas 14888 12169 0 Jan13 ? 00:00:00 postgres: EVManager EVManager 99.55.521.33(48562) idle
sas 14889 12169 0 Jan13 ? 00:00:00 postgres: EVManager EVManager 99.55.521.33(48564) idle
sas 14890 12169 0 Jan13 ? 00:00:00 postgres: EVManager EVManager 99.55.521.33(48566) idle
sas 14891 12169 0 Jan13 ? 00:00:00 postgres: EVManager EVManager 99.55.521.33(48568) idle
sas 14892 12169 0 Jan13 ? 00:00:00 postgres: EVManager EVManager 99.55.521.33(48570) idle
sas 14893 12169 0 Jan13 ? 00:00:00 postgres: EVManager EVManager 99.55.521.33(48572) idle
sas 14894 12169 0 Jan13 ? 00:00:00 postgres: EVManager EVManager 99.55.521.33(48574) idle
sas 14895 12169 0 Jan13 ? 00:00:00 postgres: EVManager EVManager 99.55.521.33(48576) idle
sas 14896 12169 0 Jan13 ? 00:00:00 postgres: EVManager EVManager 99.55.521.33(48578) idle
sas 14897 12169 0 Jan13 ? 00:00:00 postgres: EVManager EVManager 99.55.521.33(48580) idle
sas 14898 12169 0 Jan13 ? 00:00:00 postgres: EVManager EVManager 99.55.521.33(48582) idle
sas 14899 12169 0 Jan13 ? 00:00:00 postgres: EVManager EVManager 99.55.521.33(48584) idle
sas 14900 12169 0 Jan13 ? 00:03:04 postgres: EVManager EVManager 99.55.521.33(48586) idle in transaction
sas 14901 12169 0 Jan13 ? 00:05:30 postgres: EVManager EVManager 99.55.521.33(48588) idle
sas 14902 12169 0 Jan13 ? 00:00:36 postgres: EVManager EVManager 99.55.521.33(48590) idle
sas 14903 12169 0 Jan13 ? 00:06:35 postgres: EVManager EVManager 99.55.521.33(48592) idle
sas 14904 12169 0 Jan13 ? 00:05:38 postgres: EVManager EVManager 99.55.521.33(48594) idle
sas 14905 12169 0 Jan13 ? 00:00:00 postgres: EVManager EVManager 99.55.521.33(48596) idle in transaction

[gwootton · Accepted solution]

That is normal. Postgres has one process per connection, these are likely connections from the various web applications on the middle tier that make use of the database. They remain idle until the application needs to get information from the database, or write to it.