Re: FreeBSD 6.0 PostgreSQL upgrade - Mailing list pgsql-general

From Vivek Khera
Subject Re: FreeBSD 6.0 PostgreSQL upgrade
Date
Msg-id CE0E217C-8C32-4A0B-8029-03B93653654D@khera.org
Whole thread Raw
In response to FreeBSD 6.0 PostgreSQL upgrade  ("Jeff Amiel" <jeff.amiel@gmail.com>)
List pgsql-general
On Dec 19, 2006, at 3:17 AM, Jeff Amiel wrote:

> We have a production FreeBSD 6.0 system with Postgresql 8.1 where we
> have avoided upgrading/updating the ports to avoid compatability and
> other unknown issues.
> We have our supfile default date set on our production, test and
> development environments to ensure that they all have the same
> versions.

Makes sense for the OS (we use the -RELEASE versions ourselves).

For ports, what you probably want to do is have a staging environment
on which you can install and upgrade ports at will, and verify that
they work with your application.  Once verified, build packages from
those ports and then use the packages to install on your production
server(s).


Attachment

pgsql-general by date:

Previous
From: Jonathan Hedstrom
Date:
Subject: Re: A trigger question
Next
From: Glen Parker
Date:
Subject: Re: Second attempt, roll your own autovacuum