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
[EMAIL PROTECTED] 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 - [EMAIL PROTECTED] - http://www.commandprompt.com PostgreSQL Replicator -- production quality replication for PostgreSQL
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings