Re: [sysadmins] Two upgrades this weekend ...

This is a newer version of activitymail:

< # $Id: activitymail,v 1.28 2004/03/11 17:22:04 theory Exp $
---
> # $Id: activitymail 2776 2006-04-04 00:10:02Z theory $

I can revert back to the 2004/03/11 version is that would be preferrable
... ?

On Wed, 27 May 2009, Tatsuo Ishii wrote:

> Marc,
>
> I noticed commit mail message changes. If this intentional?
> At least this is slightly different from the one in PostgreSQL main
> source CVS.
>
> Before:
> pgpool-II/doc:
> pgpool-en.html (r1.35.2.1 -> r1.35.2.2)
> (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgpool/pgpool-II/doc/pgpool-en.html.diff?r1=1.35.2.1&r2=1.35.2.2)
>
> Now:
> Modified Files:
> --------------
> pgpool-II:
> pool.h (r1.36 -> r1.36.2.1)
> (http%3A%2F%2Fcvs.pgfoundry.org%2Fcgi-bin%2Fcvsweb.cgi%2Fpgpool%2Fpgpool-II%2Fpool.h%3Fr1%3D1.36%26r2%3D1.36.2.1)
> pool_process_query.c (r1.141.2.4 -> r1.141.2.5)
> (http%3A%2F%2Fcvs.pgfoundry.org%2Fcgi-bin%2Fcvsweb.cgi%2Fpgpool%2Fpgpool-II%2Fpool_process_query.c%3Fr1%3D1.141.2.4%26r2%3D1.141.2.5)
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
>
>> Fixed:
>>
>> pgfoundry# perl -e "use URI::Escape"
>> pgfoundry#
>>
>>
>> On Sun, 24 May 2009, Tatsuo Ishii wrote:
>>
>>> Seems I got same error.
>>>
>>> /cvsroot/pgpool/pgpool-II/sql/pgpool-recovery/Makefile,v <-- Makefile
>>> new revision: 1.1.2.1; 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.
>>> --
>>> Tatsuo Ishii
>>> SRA OSS, Inc. Japan
>>>
>>>> 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(at)hub(dot)org MSN .
>>>>>>>>> scrappy(at)hub(dot)org
>>>>>>>>> Yahoo . yscrappy Skype: hub.org ICQ . 7615664
>>>>>>>>>
>>>>>>>>> ---------------------------(end of broadcast)---------------------------
>>>>>>>>> If the PostgreSQL.org mailing lists are down, use the auxillary list
>>>>>>>>> pgsysadmins(at)agliodbs(dot)com
>>>>>>>>>
>>>>>>>>
>>>>>>>> ----
>>>>>>>> Marc G. Fournier Hub.Org Networking Services
>>>>>>>> (http://www.hub.org)
>>>>>>>> Email . scrappy(at)hub(dot)org MSN .
>>>>>>>> scrappy(at)hub(dot)org
>>>>>>>> Yahoo . yscrappy Skype: hub.org ICQ . 7615664
>>>>>>>>
>>>>>>>> ---------------------------(end of broadcast)---------------------------
>>>>>>>> If the PostgreSQL.org mailing lists are down, use the auxillary list
>>>>>>>> pgsysadmins(at)agliodbs(dot)com
>>>>>>>>
>>>>>>>
>>>>>>> ----
>>>>>>> Marc G. Fournier Hub.Org Networking Services
>>>>>>> (http://www.hub.org)
>>>>>>> Email . scrappy(at)hub(dot)org MSN . scrappy(at)hub(dot)org
>>>>>>> Yahoo . yscrappy Skype: hub.org ICQ . 7615664
>>>>>>>
>>>>>>> --
>>>>>>> Sent via pgsql-www mailing list (pgsql-www(at)postgresql(dot)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(at)agliodbs(dot)com
>>>>>>
>>>>>
>>>>> ----
>>>>> Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
>>>>> Email . scrappy(at)hub(dot)org MSN . scrappy(at)hub(dot)org
>>>>> Yahoo . yscrappy Skype: hub.org ICQ . 7615664
>>>>>
>>>>> ---------------------------(end of broadcast)---------------------------
>>>>> If the PostgreSQL.org mailing lists are down, use the auxillary list
>>>>> pgsysadmins(at)agliodbs(dot)com
>>>>>
>>>>
>>>> ----
>>>> Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
>>>> Email . scrappy(at)hub(dot)org MSN . scrappy(at)hub(dot)org
>>>> Yahoo . yscrappy Skype: hub.org ICQ . 7615664
>>>>
>>>> --
>>>> Sent via pgsql-www mailing list (pgsql-www(at)postgresql(dot)org)
>>>> To make changes to your subscription:
>>>> http://www.postgresql.org/mailpref/pgsql-www
>>>
>>
>> ----
>> Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
>> Email . scrappy(at)hub(dot)org MSN . scrappy(at)hub(dot)org
>> Yahoo . yscrappy Skype: hub.org ICQ . 7615664
>
> ---------------------------(end of broadcast)---------------------------
> If the PostgreSQL.org mailing lists are down, use the auxillary list pgsysadmins(at)agliodbs(dot)com
>

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