Re: 7.4 -> 7.4.1 upgrade with customization on freebsd

On Fri, 16 Jan 2004 bill.postgresql-users@mcmilleon.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

Then you will have to recompile the server, as well as dump / initdb /
restore it.

> 2) I would like to upgrade to 7.4.1 without having to re-edit any config
> files or change any paths.

Just backup the config files in $PGDATA to another directory, and toss
them back into $PGDATA after the initdb

> 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

Not a clue here, I'm not a debian user.