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
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings