Re: upgrading minor versions

From: Jan Wieck <JanWieck(at)Yahoo(dot)com>
To: Jeff Amiel <jamiel(at)istreamimaging(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: upgrading minor versions
Date: 2004-08-27 17:09:25
Message-ID: 412F6AC5.9080907@Yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 majordomo(at)postgresql(dot)org)

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Markus Bertheau 2004-08-27 17:26:38 Re: performance of IN (subquery)
Previous Message Jeff Amiel 2004-08-27 17:03:55 Re: upgrading minor versions