On 8/27/2004 12:44 PM, Jeff Amiel wrote:
Ok......still no dice. still shows 7.4.2 when I select version()... I must surely be doing something silly here...
You try to install 7.4.5 from souces over the FreeBSD Port build. The problem is that the options to configure need to be the same. You can see the options the port maintainer used by running the original pg_config with --configure option.
What you have done so far and what you should undo is that you installed a whole bunch of stuff in /usr/local/pgsql, which is an unusual location for FreeBSD.
Then you run the configure for 7.4.5 with exactly the same options, do a "gmake clean all" and as root "gmake install install-all-headers". Then you restart the postmaster and are in business.
Jan
Jan Wieck wrote:
On 8/27/2004 12:21 PM, Jeff Amiel wrote:
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...
try
eval ./configure `/usr/bin/pg_config --configure`
Jan
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
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
-- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== [EMAIL PROTECTED] #
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
