Re: [GENERAL] upgrade postgreSQL

Under FreeBSD, you should be using the ports. In this case, you could
simply use the following commands in the postgresql port directory:
make
pkg_delete postgresql-6.5.2
make install

Though the procedure was simple, there was a little gotcha. You need to:
psql template1
select oid,* from pg_database;
remove one of the two template1 tables by using the oid.

Good luck,
Marc

On Wed, 26 Jan 2000, Matthias Zehnder wrote:

> I got the file <<.patch>> and tried to upgrade postgres
> sous FreeBSD with the command patch from the version 6.5.2 to
> the version 6.5.3 but it doesn't work. Could somebody
> explain to me how to upgrade postgres on my server.
>
> Thank's for your help
>
>
>
> ______________________________________
>
> Matthias Zehnder - Informatique
> E-mail: matthias(dot)zehnder(at)mcnet(dot)ch
> ______________________________________
>
> M & C net
> M&C Management & Communications SA
> A VIA NET.WORKS COMPANY
>
> Rue de Romont 35, CH-1700 Fribourg
> Tl.: ++41 (0)26 347 20 40, fax: ++41 (0)26 347 20 49
> E-mail: office(at)mcnet(dot)ch, http://www.mcnet.ch
>
>
> ************
>
>