Re: Version Problems on Mac OS X.2 Jaguar

On Thursday, January 9, 2003, at 02:02 PM, Babu Khan wrote:

> --- Jeffrey Bohmer <bohmer@visionlink.org> wrote:
>>
>> Do you have an existing 7.2 dump that could be used
>> in a restore now?  If so, you can install 7.3 and
>> restore from that dump.  If not, then you'll need to
>> get 7.2.x (any version of it) on your 10.2 machine
>> to make a dump.  Or, move your existing 7.2.1.5
>> install to a 10.1 machine and make a dump there.
>>
> How do I move existing install onto other 10.1
> machine??
>
> That looks like my only hope now...
>

You can make an archive of the database directory, transfer it over and
expand it.  If postgres isn't install on the other box, you'll probably
want to compile it or re-install it from a pagkage if that's where you
got it.  Trying to transfer the libraries and executables would be a
pain.

>> For 7.2.x on 10.2, you could try all three versions
>> of Marc's distribution for a functional pg_dump or
>> pg_dumpall.  Or, install fink and try to get 7.2.x
>> working via fink.  Otherwise, you'll need to tweak
>> the 7.2 sources manually (sorry, I can't help you
>> with this last one).
>>
>
> Don't want to mess around with Fink, but is there a
> way to have 2 version installions on the same machine?
>
Yes,  when i build postgres, i specify the prefix directory using
--prefix=/somedir  So my development box has a /usr/pg-7.2 and a
/usr/pg-7.3 where the respective installations are done.

> Regards,
> babu.
>> - Jeff
>>
>>
>>> You will have to dump 7.2 before moving to 7.3.
>> 7.3 requires a db init.  So your best bet is to
>> recompile 7.2 on 10.2.
>>>
>>>
>>> On Thursday, January 9, 2003, at 01:17 PM, Babu
>> Khan wrote:
>>>
>>>> Thanks Jeffrey,
>>>>
>>>> I am aware of the page by Marc Liyanage, infact I
>>>> tried to update according to the instructions, but
>> my
>>>> problem is that pg_dump is not working ( it gives
>> some
>>>> undefined variable in libararies errors), so if I
>> need
>>>> to upgrade to 7.3 from 7.2.1.5 can I do it without
>>>> backing up the data. i understand this is only
>>>> possible if internal table structures, etc haven't
>>>> changed in 7.3 from 7.2.1.5
>>>>
>>>> babu.
>>>> --- Jeffrey Bohmer <bohmer@visionlink.org> wrote:
>>>>>
>>>>> 7.3 and later compile on OS X 10.2, 7.2.x don't
>>>>> without tweaks.  Upgrading is probably your best
>>>>> bet.
>>>>>
>>>>> Some people have used fink to get 7.2.x working
>> with
>>>>> 10.2.  I used a distribution put together by Marc
>>>>> Liyanage (sp?), which I can't find on the web
>>>>> anymore.  I still have my copies of this
>>>>> distribution for 7.2.1, 7.2.2, and 7.2.3.  If you
>>>>> want any of them, contact me off-list.
>>>>>
>>>>> - Jeff
>>>>>
>>>>>> Hi Guys,
>>>>>>
>>>>>> I have a BIIG poblem.
>>>>>>
>>>>>> We had some application running on Mac OS X.1
>> using
>>>>>> postgres 7.2.1.5. Recently we decided to upgrade
>> to
>>>>>> Mac OS X.2 Jaguar.
>>>>>>
>>>>>> Now this is where the problem starts. After the
>>>>>> upgrade although the application runs, i am
>> unable
>>>>> to
>>>>>> run psql, pg_dump etc. After research, I learnt
>>>>> that
>>>>>> this is because postgres was compiled for OS
>> 10.1
>>>>> and
>>>>>> now I should re-compile it for 10.2. For this I
>>>>> need
>>>>>> to backup the data right? or can I just simply
>> run
>>>>> the
>>>>>> postgres.pkg file for 7.2.1.5 again and that
>> will
>>>>> not
>>>>>> disturb the current data in the database??
>>>>>>
>>>>>> Thanks for any help....
>>>>>>
>>>>>> babu
>>>>> --
>>>>>
>>>>> Jeff Bohmer
>>>>> VisionLink, Inc.
>>>>> _________________________________
>>>>> 303.402.0170
>>>>> www.visionlink.org
>>>>> _________________________________
>>>>> People. Tools. Change. Community.
>>>>>
>>>>> ---------------------------(end of
>>>>> broadcast)---------------------------
>>>>> TIP 5: Have you checked our extensive FAQ?
>>>>>
>>
>>>> http://www.postgresql.org/users-lounge/docs/faq.html
>>>>
>>>>
>>>> __________________________________________________
>>>> Do you Yahoo!?
>>>> Yahoo! Mail Plus - Powerful. Affordable. Sign up
>> now.
>>>> http://mailplus.yahoo.com
>>>>
>>>> ---------------------------(end of
>> broadcast)---------------------------
>>>> TIP 1: subscribe and unsubscribe commands go to
>> majordomo@postgresql.org
>>>
>>>
>>> ---------------------------(end of
>> broadcast)---------------------------
>>> TIP 5: Have you checked our extensive FAQ?
>>>
>>
>> http://www.postgresql.org/users-lounge/docs/faq.html
>>
>> --
>>
>> Jeff Bohmer
>> VisionLink, Inc.
>> _________________________________
>> 303.402.0170
>> www.visionlink.org
>> _________________________________
>> People. Tools. Change. Community.
>>
>> ---------------------------(end of
>> broadcast)---------------------------
>> TIP 5: Have you checked our extensive FAQ?
>>
>> http://www.postgresql.org/users-lounge/docs/faq.html
>
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster