Re: 7.4 -> 7.4.1 upgrade with customization on freebsd - Mailing list pgsql-general

From scott.marlowe
Subject Re: 7.4 -> 7.4.1 upgrade with customization on freebsd
Date
Msg-id Pine.LNX.4.33.0401191040240.11187-100000@css120.ihs.com
Whole thread Raw
In response to 7.4 -> 7.4.1 upgrade with customization on freebsd  (<bill.postgresql-users@mcmilleon.com>)
Responses Re: 7.4 -> 7.4.1 upgrade with customization on freebsd  (Fernando Schapachnik <fernando@mecon.gov.ar>)
List pgsql-general
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.


pgsql-general by date:

Previous
From: Mental
Date:
Subject: Re: importing data
Next
From: "scott.marlowe"
Date:
Subject: Re: [pgsql-advocacy] New PostgreSQL search resource