Re: Is it possible to start two instances of postgresql?

kah_hang_ang(at)toray(dot)com(dot)my writes:
> Is it possible to start two instances of postgresql with different port and
> directory which run simultaneously?

Certainly. We have one HACMP cluster which hosts 14 PostgreSQL
instances across two physical boxes. (If one went down, they'd all
migrate to the survivor...)

> If can then will this cause any problem or performance drop down?

There certainly can be; the databases will be sharing disks, memory,
and CPUs, so if they are avidly competing for resources, the
competition is sure to have some impact on performance.

Flip side: That 14 database cluster has several databases that are
known to be very lightly used; they *aren't* competing, and aren't a
problem.

Consider it obvious that if you haven't enough memory or I/O bandwidth
to cover your two PG instances, you'll find performance sucks... If
you have enough, then it can work fine...
--
select 'cbbrowne' || '@' || 'acm.org';
http://cbbrowne.com/info/linuxxian.html
"At Microsoft, it doesn't matter which file you're compiling, only
which flags you #define." -- Colin Plumb