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

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