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.zehnder@mcnet.ch
> ______________________________________
> 
> M & C net
> M&C Management & Communications SA
> A VIA NET.WORKS COMPANY
> 
> Rue de Romont 35, CH-1700 Fribourg
> T�l.: ++41 (0)26 347 20 40, fax: ++41 (0)26 347 20 49
> E-mail: office@mcnet.ch, http://www.mcnet.ch
> 
> 
> ************
> 
>