Dan,
Sure, just bring it up in a different directory and have it listen on a
different port. You could either dump/restore to get the data over to it or
use a replication tool such as slony or mammoth to do the deed. The latter
method has the benefit of keeping it up to date while you poke around if you
have a database which gets written to during your switchover time.
On Tue, 8 Nov 2005, Dan The Man wrote:
Hi,
I have enough resources on my 3 postgresql servers to run more than one
instance of postgres. Is there a way to keep my production db up and running
in 8.0.3 while I also run 8.1.0 on the same server? Then, I could copy the
data and support two databases until things looked good. Then, I'd shutdown
8.0.3.
--
Jeff Frost, Owner <jeff@xxxxxxxxxxxxxxxxxxxxxx>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
