kah_hang_ang@xxxxxxxxxxxx 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
