Re: Upgrade to PG 8 before starting major development?

--- Lan Barnes <lan@falleagle.net> wrote:

> I'm about to embark on some major development of
> data bases both at home
> and at work. In both cases, my servers, which are
> functioning perfectly,
> are installed with FC3 (postgresql-7.4.6-1.FC3.1)
>
> Would it be recommended to upgrade to FC4 before
> starting to get pg 8? I
> really don't want to spend the time right now, but I
> also don't want to
> pay for it later with an upgrade that will include
> table and data
> migration.
>
> Feedback?
>
> TIA,
>
> --
> Lan Barnes                    lan@falleagle.net
> Linux Guy, SCM Specialist     858-354-0616

Tom Lane will be the resident RH/PGSQL expert (and
maybe a few others), but i would upgrade for the exact
reason you outlined.  a few hours today may well end
up resulting in many hours and headaches down the
road.

do you necessarily need to upgrade to FC4 in order to
upgrade to pgsql 8.x?  maybe you csn just update the
db.  then again, if you will migrate to FC4 in the
future...  there's no time like the present.

however, if Tom has some insight into this - go with
his insight b/c he knows a lot more than i do.


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com