Best way of upgrading postgresql in production?

2008-05-29 Thread Gunther Mayer
Hi guys, I've been grappling with this and read all sorts of email threads and blog posts but I still have no good solution to the following problem: I want to upgrade a postgresql installation on FreeBSD 6.3 from 8.2 to 8.3 as we'd like to take advantage of its new features and performance

Re: Best way of upgrading postgresql in production?

2008-05-29 Thread Bill Moran
In response to Gunther Mayer [EMAIL PROTECTED]: I've been grappling with this and read all sorts of email threads and blog posts but I still have no good solution to the following problem: I want to upgrade a postgresql installation on FreeBSD 6.3 from 8.2 to 8.3 as we'd like to take

Re: Best way of upgrading postgresql in production?

2008-05-29 Thread Gunther Mayer
Bill Moran wrote: In response to Gunther Mayer [EMAIL PROTECTED]: I've been grappling with this and read all sorts of email threads and blog posts but I still have no good solution to the following problem: I want to upgrade a postgresql installation on FreeBSD 6.3 from 8.2 to 8.3 as we'd

Re: Best way of upgrading postgresql in production?

2008-05-29 Thread Shelby Cain
On Thu, 2008-05-29 at 18:31 +0200, Gunther Mayer wrote: Ok, you're probably right, I just haven't worked with jails before and have just read the wrong articles. I will investigate how I could install the newer version in a jail and keep both running at the same time during the upgrade,

Re: Best way of upgrading postgresql in production?

2008-05-29 Thread Shelby Cain
On Thu, 2008-05-29 at 16:00 -0500, Shelby Cain wrote: guide web page as a gudie for getting a different version of Postgresql running in a jail when the host is already running a different version of Postgresql. This is what happens when you don't hit the wrong button in your mail client. :-/