upgrading minor versions - Mailing list pgsql-general

From Jeff Amiel
Subject upgrading minor versions
Date
Msg-id 412F5F77.1000202@istreamimaging.com
Whole thread Raw
In response to Alter field type?  (Bjørn T Johansen <btj@havleik.no>)
Responses Re: upgrading minor versions  (Jan Wieck <JanWieck@Yahoo.com>)
Re: upgrading minor versions  (Doug McNaught <doug@mcnaught.org>)
List pgsql-general
This may sound like a silly question....
I am currently running 7.4.2.
I would like to upgrade to 7.4.5...

So I downloaded postgresql-7.4.5.tar.gz
<ftp://ftp21.us.postgresql.org/pub/postgresql/v7.4.5/postgresql-7.4.5.tar.gz>
uncompressed...
configure...
make
make install

I run psql and it gives me the" Welcome to psql 7.4.5, the PostgreSQL
interactive terminal."
So far so good...it says 7.4.5.

but when I select version() from the database that I connected to with
psql, I still receive:
PostgreSQL 7.4.2 on i386-portbld-freebsd5.2.1, compiled by GCC cc (GCC)
3.3.3 [FreeBSD] 20031106

Is the database itself versioned?

Do I need to do a dump/restore?

Jeff




pgsql-general by date:

Previous
From: Joseph Shraibman
Date:
Subject: Re: performance of IN (subquery)
Next
From: Jan Wieck
Date:
Subject: Re: upgrading minor versions