Thread: Upgrade to PG 8 before starting major development?
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
On Mon, Jan 30, 2006 at 10:49:02AM -0800, Lan Barnes 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, > Answering my own question. I'm going for it! (I got a second server at work to bring up _before_ taking the other down -- feels lots safer :-) -- Lan Barnes lan@falleagle.net Linux Guy, SCM Specialist 858-354-0616
--- 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
On Mon, Jan 30, 2006 at 10:49:02 -0800, 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? FC3 is legacy now. You should probably be planning to upgrade to FC4 soon or FC5 in several months, if you want to skip FC4. The migration later shouldn't be all that bad. I think a bigger factor is starting your development with more recent versions of tools than you will find in FC3. Based on what I am seeing on the fedora lists, you probably don't want to try out FC5 just yet. You might want to compare what versions of key packages (you care about) are available for FC3, FC4 and FC5 and see if that helps with your decision.
Hi Lan, why don't you just compile Postgres and install it on your existing server? You could even run it besides your productive PG 7.xxx if you just switch the 8.1 to another port like 5433. I dont know about FC3 but at least SuSE keeps its own binaries in /usr/bin and this seems to be something like a tradition for the commercial distributions. If you follow PG's documentation with default locations your own binaries would land in /usr/local/pgsql. No problem. Lan Barnes schrieb: >On Mon, Jan 30, 2006 at 10:49:02AM -0800, Lan Barnes 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, >> >> >> > >Answering my own question. I'm going for it! (I got a second server at >work to bring up _before_ taking the other down -- feels lots safer :-) > > >