Re: [sysadmins] Two upgrades this weekend ... - Mailing list pgsql-www

Please try now ...

On Sun, 24 May 2009, Marc G. Fournier wrote:

>
> Fixing, will advise when completed ...
>
> On Sun, 24 May 2009, Tatsuo Ishii wrote:
>
>> Marc,
>> 
>> I got an error when committing a file. Could you take a look at?
>> 
>> /cvsroot/pgpool/pgpool-II/sql/pgpool-recovery/Makefile,v  <--  Makefile
>> new revision: 1.2; previous revision: 1.1
>> done
>> Can't locate URI/Escape.pm in @INC (@INC contains: 
>> /usr/local/lib/perl5/5.8.9/BSDPAN /usr/local/lib/perl5/site_perl/5.8.9/mach 
>> /usr/local/lib/perl5/site_perl/5.8.9 /usr/local/lib/perl5/5.8.9/mach 
>> /usr/local/lib/perl5/5.8.9 .) at /usr/local/bin/activitymail line 52.
>> 
>>> Okay, everything *appears* to be fine ... only concern I have is mailman,
>>> as I don't know how to test that, but it *looks* like postfix is
>>> processing emails properly ...
>>> 
>>> Please go through and let me know, as I said, worst case, we have to
>>> revert back to the 6.x format, but would prefer to resolve any issues vs
>>> just switch back ...
>>> 
>>> On Sat, 23 May 2009, Marc G. Fournier wrote:
>>> 
>>>> 
>>>> I am starting this on pgfoundry.org right now ... the procedure is very
>>>> simple (but longish):
>>>> 
>>>> shutdown VPS
>>>> use rsync to create a duplicate
>>>> upgrade OS to 7.x
>>>> restart VPS
>>>> upgrade all ports to 7.x
>>>> restart VPS to ensure all services restart
>>>> 
>>>> I won't be going to bed until it is finished, so there will be no delays 
>>>> for
>>>> rebuilding the ports themselves ...
>>>> 
>>>> On Sat, 23 May 2009, Marc G. Fournier wrote:
>>>> 
>>>>> On Sat, 23 May 2009, Stefan Kaltenbrunner wrote:
>>>>> 
>>>>>> Robert Treat wrote:
>>>>>>> On Saturday 23 May 2009 00:35:05 Marc G. Fournier wrote:
>>>>>>>> I need to perform two upgrades this weekend:
>>>>>>>>
>>>>>>>>    pgfoundry.org
>>>>>>>>    pugs.postgresql.org
>>>>>>>> 
>>>>>>>> We've been having an odd issue with our 64bit servers of late, and 
>>>>>>>> we've
>>>>>>>> been slowly eliminating potential problems.  Right now, I am working 
>>>>>>>> on
>>>>>>>> eliminating a potential issue with running FreeBSD 6.x VPS/libraries 
>>>>>>>> on
>>>>>>>> the FreeBSD 7.x servers, something that all three of our current 
>>>>>>>> 64bit
>>>>>>>> servers have in varying degrees.
>>>>>>>>
>>>>>>>>    Both pgfoundry.org and pugs.postgresql.org are running FreeBSD 6.x
>>>>>>>> ports
>>>>>>>> / libraries, so I will be upgrade them to proper 7.x VPSs.
>>>>>>>>
>>>>>>>>    The downtime tends to vary, but will be at least 2hrs each, and I
>>>>>>>> will
>>>>>>>> do them sequentially .
>>>>>>>>
>>>>>>>>    No config files will be changed, only the binaries upgraded /
>>>>>>>> recompiled
>>>>>>>> to be proper "native 7.x binaries" ...
>>>>>>>> 
>>>>>>> 
>>>>>>> Thanks for the heads up... any chance you can email pgsql-www when the
>>>>>>> downtime begins (and optionally when it is done) ?
>>>>>> 
>>>>>> it might also be important to mention that depending on what the
>>>>>> definition of "binaries upgraded" is that our version of gforge might 
>>>>>> not
>>>>>> work with certain newer stuff...
>>>>> 
>>>>> I'm going to duplicate pgfoundry *before* do the upgrade, so that if it
>>>>> does fail completely, I can revert back to the 6.x version quickly ...
>>>>> 
>>>>> And yes, will send out a notice both before, and when completed ...
>>>>> 
>>>>> 
>>>>> ----
>>>>> Marc G. Fournier           Hub.Org Networking Services 
>>>>> (http://www.hub.org)
>>>>> Email . scrappy@hub.org                              MSN . 
>>>>> scrappy@hub.org
>>>>> Yahoo . yscrappy               Skype: hub.org        ICQ . 7615664
>>>>> 
>>>>> ---------------------------(end of broadcast)---------------------------
>>>>> If the PostgreSQL.org mailing lists are down, use the auxillary list
>>>>> pgsysadmins@agliodbs.com
>>>>> 
>>>> 
>>>> ----
>>>> Marc G. Fournier           Hub.Org Networking Services 
>>>> (http://www.hub.org)
>>>> Email . scrappy@hub.org                              MSN . 
>>>> scrappy@hub.org
>>>> Yahoo . yscrappy               Skype: hub.org        ICQ . 7615664
>>>> 
>>>> ---------------------------(end of broadcast)---------------------------
>>>> If the PostgreSQL.org mailing lists are down, use the auxillary list
>>>> pgsysadmins@agliodbs.com
>>>> 
>>> 
>>> ----
>>> Marc G. Fournier           Hub.Org Networking Services 
>>> (http://www.hub.org)
>>> Email . scrappy@hub.org                              MSN . scrappy@hub.org
>>> Yahoo . yscrappy               Skype: hub.org        ICQ . 7615664
>>> 
>>> --
>>> Sent via pgsql-www mailing list (pgsql-www@postgresql.org)
>>> To make changes to your subscription:
>>> http://www.postgresql.org/mailpref/pgsql-www
>> 
>> ---------------------------(end of broadcast)---------------------------
>> If the PostgreSQL.org mailing lists are down, use the auxillary list 
>> pgsysadmins@agliodbs.com
>> 
>
> ----
> Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
> Email . scrappy@hub.org                              MSN . scrappy@hub.org
> Yahoo . yscrappy               Skype: hub.org        ICQ . 7615664
>
> ---------------------------(end of broadcast)---------------------------
> If the PostgreSQL.org mailing lists are down, use the auxillary list 
> pgsysadmins@agliodbs.com
>

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email . scrappy@hub.org                              MSN . scrappy@hub.org
Yahoo . yscrappy               Skype: hub.org        ICQ . 7615664