RDBMS Information - PostgreSQL - How to remove the Postgres ghost processes
Purpose
This page outline some possible solutions when you see on your Postgres server many ghost process that can lead to crash or performance problem in your analysis.
These solutions have been picked from 3rd part websites from the internet and might help you get rid of this scenario.
Applicable in CAST Version
| Release | Yes/No |
|---|---|
| 8.3.x | ✅ |
| 8.2.x | ✅ |
| 8.1.x | ✅ |
| 8.0.x | ✅ |
| 7.3.x | ✅ |
| 7.2.x | ✅ |
Applicable RDBMS
| RDBMS | Yes/No |
|---|---|
| Oracle Server | ❌ |
| Microsoft SQL Server | ❌ |
| CSS2 | ✅ |
| CSS1 | ✅ |
Applicable Platform or
| Platform or | Yes/No |
|---|---|
Details
To get rid of the issue, you may try the mentioned solutions from the below external links:
- http://superuser.com/questions/553045/fatal-lock-file-postmaster-pid-already-exists
- http://forums.enterprisedb.com/posts/list/1957.page
- http://www.postgresql.org/message-id/CAALYute4UraTJ62Lz_NuYq8njVP8Ut8_zpj_MVnAyTp7+eV6Bg@mail.gmail.com
Notes/comments
Related Pages