topic Re: SAS Postgress servcies in idle and in transaction in Administration and Deployment https://communities.sas.com/t5/Administration-and-Deployment/SAS-Postgress-servcies-in-idle-and-in-transaction/m-p/717990#M21516 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. Tue, 09 Feb 2021 19:46:49 GMT gwootton 2021-02-09T19:46:49Z SAS Postgress servcies in idle and in transaction https://communities.sas.com/t5/Administration-and-Deployment/SAS-Postgress-servcies-in-idle-and-in-transaction/m-p/717939#M21514 <P>All,</P> <P>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 &nbsp;seen this idle message when I grep for sas(no impacts on users yet).</P> <P>sas 12978 12169 0 Jan13 ? 01:27:49 postgres: SharedServices SharedServices 99.55.521.33(46132) idle<BR />sas 12979 12169 0 Jan13 ? 00:02:53 postgres: SharedServices SharedServices 99.55.521.33(46134) idle<BR />sas 12980 12169 0 Jan13 ? 00:00:40 postgres: SharedServices SharedServices 99.55.521.33(46136) idle<BR />sas 12981 12169 0 Jan13 ? 00:00:12 postgres: SharedServices SharedServices 99.55.521.33(46138) idle<BR />sas 12982 12169 0 Jan13 ? 00:00:03 postgres: SharedServices SharedServices 99.55.521.33(46140) idle<BR />sas 12983 12169 0 Jan13 ? 00:00:00 postgres: SharedServices SharedServices 99.55.521.33(46142) idle<BR />sas 12984 12169 0 Jan13 ? 00:00:00 postgres: SharedServices SharedServices 99.55.521.33(46144) idle<BR />sas 12985 12169 0 Jan13 ? 00:00:00 postgres: SharedServices SharedServices 99.55.521.33(46146) idle<BR />sas 12986 12169 0 Jan13 ? 00:00:00 postgres: SharedServices SharedServices 99.55.521.33(46148) idle<BR />sas 13524 12261 0 Jan13 ? 00:00:00 postgres: TAServices TAServices 99.55.521.33(46948) idle<BR />sas 13525 12261 0 Jan13 ? 00:00:00 postgres: TAServices TAServices 99.55.521.33(46950) idle<BR />sas 13526 12261 0 Jan13 ? 00:00:00 postgres: TAServices TAServices 99.55.521.33(46952) idle<BR />sas 13527 12261 0 Jan13 ? 00:00:00 postgres: TAServices TAServices 99.55.521.33(46954) idle<BR />sas 13528 12261 0 Jan13 ? 00:00:00 postgres: TAServices TAServices 99.55.521.33(46956) idle<BR />sas 13529 12261 0 Jan13 ? 00:00:00 postgres: TAServices TAServices 99.55.521.33(46958) idle<BR />sas 13530 12261 0 Jan13 ? 00:00:00 postgres: TAServices TAServices 99.55.521.33(46960) idle<BR />sas 13531 12261 0 Jan13 ? 00:00:00 postgres: TAServices TAServices 99.55.521.33(46962) idle<BR />sas 13532 12261 0 Jan13 ? 00:00:00 postgres: TAServices TAServices 99.55.521.33(46964) idle<BR />sas 13533 12261 0 Jan13 ? 00:00:00 postgres: TAServices TAServices 99.55.521.33(46966) idle<BR />sas 13534 12301 0 Jan13 ? 00:00:00 postgres: dcmdb dcmdb 99.55.521.33(51488) idle<BR />sas 13535 12301 0 Jan13 ? 00:00:00 postgres: dcmdb dcmdb 99.55.521.33(51490) idle<BR />sas 13536 12301 0 Jan13 ? 00:00:00 postgres: dcmdb dcmdb 99.55.521.33(51492) idle<BR />sas 13537 12301 0 Jan13 ? 00:00:00 postgres: dcmdb dcmdb 99.55.521.33(51494) idle<BR />sas 13538 12301 0 Jan13 ? 00:00:00 postgres: dcmdb dcmdb 99.55.521.33(51496) idle<BR />sas 13539 12301 0 Jan13 ? 00:00:00 postgres: dcmdb dcmdb 99.55.521.33(51498) idle<BR />sas 13540 12301 0 Jan13 ? 00:00:00 postgres: dcmdb dcmdb 99.55.521.33(51500) idle<BR />sas 13541 12301 0 Jan13 ? 00:00:00 postgres: dcmdb dcmdb 99.55.521.33(51502) idle<BR />sas 13542 12301 0 Jan13 ? 00:00:00 postgres: dcmdb dcmdb 99.55.521.33(51504) idle<BR />sas 13543 12301 0 Jan13 ? 00:00:00 postgres: dcmdb dcmdb 99.55.521.33(51506) idle<BR />sas 13544 12169 0 Jan13 ? 00:21:21 postgres: SharedServices SharedServices 99.55.521.33(46844) idle<BR />sas 13545 12169 0 Jan13 ? 00:00:14 postgres: SharedServices SharedServices 99.55.521.33(46846) idle<BR />sas 13546 12169 0 Jan13 ? 00:00:02 postgres: SharedServices SharedServices 99.55.521.33(46848) idle<BR />sas 13547 12169 0 Jan13 ? 00:00:00 postgres: SharedServices SharedServices 99.55.521.33(46850) idle<BR />sas 13548 12169 0 Jan13 ? 00:00:00 posRtgres: SharedServices SharedServices 99.55.521.33(46852) idle<BR />sas 13549 12169 0 Jan13 ? 00:00:00 postgres: SharedServices SharedServices 99.55.521.33(46854) idle<BR />sas 13550 12169 0 Jan13 ? 00:00:00 postgres: SharedServices SharedServices 99.55.521.33(46856) idle<BR />sas 13551 12169 0 Jan13 ? 00:00:00 postgres: SharedServices SharedServices 99.55.521.33(46858) idle<BR />sas 13552 12169 0 Jan13 ? 00:00:00 postgres: SharedServices SharedServices 99.55.521.33(46860) idle<BR />sas 13554 12169 0 Jan13 ? 00:00:00 postgres: SharedServices SharedServices 99.55.521.33(46862) idle<BR />sas 14128 12393 0 Jan13 ? 00:01:17 postgres: fsmgradmin fsmgrdb 99.55.521.33(60710) idle<BR />sas 14129 12393 0 Jan13 ? 00:00:00 postgres: fsmgradmin fsmgrdb 99.55.521.33(60712) idle<BR />sas 14130 12393 0 Jan13 ? 00:00:00 postgres: fsmgradmin fsmgrdb 99.55.521.33(60714) idle<BR />sas 14131 12393 0 Jan13 ? 00:00:00 postgres: fsmgradmin fsmgrdb 99.55.521.33(60716) idle<BR />sas 14132 12393 0 Jan13 ? 00:00:00 postgres: fsmgradmin fsmgrdb 99.55.521.33(60718) idle<BR />sas 14133 12393 0 Jan13 ? 00:00:00 postgres: fsmgradmin fsmgrdb 99.55.521.33(60720) idle<BR />sas 14134 12393 0 Jan13 ? 00:00:00 postgres: fsmgradmin fsmgrdb 99.55.521.33(60722) idle<BR />sas 14135 12393 0 Jan13 ? 00:00:00 postgres: fsmgradmin fsmgrdb 99.55.521.33(60724) idle<BR />sas 14136 12393 0 Jan13 ? 00:00:00 postgres: fsmgradmin fsmgrdb 99.55.521.33(60726) idle<BR />sas 14137 12393 0 Jan13 ? 00:00:00 postgres: fsmgradmin fsmgrdb 99.55.521.33(60728) idle<BR />sas 14138 12331 0 Jan13 ? 00:00:00 postgres: rmdbuser DataRemediationDataServer 99.55.521.33(42252) idle<BR />sas 14139 12331 0 Jan13 ? 00:00:00 postgres: rmdbuser DataRemediationDataServer 99.55.521.33(42254) idle<BR />sas 14141 12331 0 Jan13 ? 00:00:00 postgres: rmdbuser DataRemediationDataServer 99.55.521.33(42256) idle<BR />sas 14142 12331 0 Jan13 ? 00:00:00 postgres: rmdbuser DataRemediationDataServer 99.55.521.33(42258) idle<BR />sas 14143 12331 0 Jan13 ? 00:00:00 postgres: rmdbuser DataRemediationDataServer 99.55.521.33(42260) idle<BR />sas 14144 12331 0 Jan13 ? 00:00:00 postgres: rmdbuser DataRemediationDataServer 99.55.521.33(42262) idle<BR />sas 14145 12331 0 Jan13 ? 00:00:00 postgres: rmdbuser DataRemediationDataServer 99.55.521.33(42264) idle<BR />sas 14146 12331 0 Jan13 ? 00:00:00 postgres: rmdbuser DataRemediationDataServer 99.55.521.33(42266) idle</P> <P>sas 14863 12169 0 Jan13 ? 00:00:00 postgres: EVManager EVManager 99.55.521.33(48536) idle in transaction<BR />sas 14885 12169 0 Jan13 ? 00:00:00 postgres: EVManager EVManager 99.55.521.33(48558) idle<BR />sas 14887 12169 0 Jan13 ? 00:00:00 postgres: EVManager EVManager 99.55.521.33(48560) idle<BR />sas 14888 12169 0 Jan13 ? 00:00:00 postgres: EVManager EVManager 99.55.521.33(48562) idle<BR />sas 14889 12169 0 Jan13 ? 00:00:00 postgres: EVManager EVManager 99.55.521.33(48564) idle<BR />sas 14890 12169 0 Jan13 ? 00:00:00 postgres: EVManager EVManager 99.55.521.33(48566) idle<BR />sas 14891 12169 0 Jan13 ? 00:00:00 postgres: EVManager EVManager 99.55.521.33(48568) idle<BR />sas 14892 12169 0 Jan13 ? 00:00:00 postgres: EVManager EVManager 99.55.521.33(48570) idle<BR />sas 14893 12169 0 Jan13 ? 00:00:00 postgres: EVManager EVManager 99.55.521.33(48572) idle<BR />sas 14894 12169 0 Jan13 ? 00:00:00 postgres: EVManager EVManager 99.55.521.33(48574) idle<BR />sas 14895 12169 0 Jan13 ? 00:00:00 postgres: EVManager EVManager 99.55.521.33(48576) idle<BR />sas 14896 12169 0 Jan13 ? 00:00:00 postgres: EVManager EVManager 99.55.521.33(48578) idle<BR />sas 14897 12169 0 Jan13 ? 00:00:00 postgres: EVManager EVManager 99.55.521.33(48580) idle<BR />sas 14898 12169 0 Jan13 ? 00:00:00 postgres: EVManager EVManager 99.55.521.33(48582) idle<BR />sas 14899 12169 0 Jan13 ? 00:00:00 postgres: EVManager EVManager 99.55.521.33(48584) idle<BR />sas 14900 12169 0 Jan13 ? 00:03:04 postgres: EVManager EVManager 99.55.521.33(48586) idle in transaction<BR />sas 14901 12169 0 Jan13 ? 00:05:30 postgres: EVManager EVManager 99.55.521.33(48588) idle<BR />sas 14902 12169 0 Jan13 ? 00:00:36 postgres: EVManager EVManager 99.55.521.33(48590) idle<BR />sas 14903 12169 0 Jan13 ? 00:06:35 postgres: EVManager EVManager 99.55.521.33(48592) idle<BR />sas 14904 12169 0 Jan13 ? 00:05:38 postgres: EVManager EVManager 99.55.521.33(48594) idle<BR />sas 14905 12169 0 Jan13 ? 00:00:00 postgres: EVManager EVManager 99.55.521.33(48596) idle in transaction</P> <P>&nbsp;</P> Tue, 09 Feb 2021 16:09:06 GMT https://communities.sas.com/t5/Administration-and-Deployment/SAS-Postgress-servcies-in-idle-and-in-transaction/m-p/717939#M21514 sathya66 2021-02-09T16:09:06Z Re: SAS Postgress servcies in idle and in transaction https://communities.sas.com/t5/Administration-and-Deployment/SAS-Postgress-servcies-in-idle-and-in-transaction/m-p/717990#M21516 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. Tue, 09 Feb 2021 19:46:49 GMT https://communities.sas.com/t5/Administration-and-Deployment/SAS-Postgress-servcies-in-idle-and-in-transaction/m-p/717990#M21516 gwootton 2021-02-09T19:46:49Z