Pooja Khobragade <Pooja_Khobragade@persistent.co.in> wrote:
> I guess I get this error because there are two versions of
> postgreSQL installed on the same machine.
It sounds like that may be part of the problem, or an improper or
incomplete attempt at an update to a new major version.
On the other hand, there is definitely more to the problem than
running two versions on the same machine. In our shop, we do that
all the time without problems. It can work fine as long as you
manage it correctly.
Have you performed an upgrade to a new major version of PostgreSQL
lately? Have you ever moved or copied PostgreSQL executable files
from one location to another?
-Kevin