Re: 7.4 -> 7.4.1 upgrade with customization on freebsd

Hello,

Well... 7.4 to 7.4.1 is a direct upgrade. You do not have to do a
reinitdb which means you do
not have to reconfigure the system. I can't help you with your BSD
specific issues (I don't know much about it)
but from the PostgreSQL perspective, you should be abble to just upgrade.

One note would be to backup your data/ directory, and then remove
postgresql in whichever manner
BSD does. Then install 7.4.1, and restore your data directory.

Any people using BSD want to help on this one a little?

Sincerely,

Joshua D. Drake

bill(dot)postgresql-users(at)mcmilleon(dot)com wrote:

>I installed 7.4 from the FreeBSD ports collection (I'm running 4.9-RELEASE).
>Did nothing special, just make && make install and all was well.
>
>I now have updated my ports collection via cvsup and see that the 7.4.1 port
>is available. So now I have several, very specific needs:
>
>1) having now done some development in 7.4, I've decided I need to be able
>to exceed the default limit of 16 arguments for plpgsql functions
>
>2) I would like to upgrade to 7.4.1 without having to re-edit any config
>files or change any paths.
>
>3) I would like to prevent the database shown by "pkg_version -v" from
>having one entry for 7.4 and another for 7.4.1
>
>Suggestions? Caveat: I'm a java + sql centered coder and makefiles make me
>wince.
>
>
>Bill McMilleon
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>
>

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd(at)commandprompt(dot)com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL