Thread: upgrade postgreSQL

upgrade postgreSQL

From
"Matthias Zehnder"
Date:
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


Re: [GENERAL] upgrade postgreSQL

From
Marc Tardif
Date:
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
>
>
> ************
>
>