Thread

  1. 7.2.3 patching done

    Tom Lane <tgl@sss.pgh.pa.us> — 2002-09-30T21:02:51Z

    I'm done making back-patches for 7.2.3.  Over to you, Bruce ...
    attached is the REL7_2_STABLE branch history since 7.2.2.
    
    			regards, tom lane
    
    2002-09-30 16:57  tgl
    
    	* src/backend/utils/adt/: date.c, datetime.c (REL7_2_STABLE):
    	Back-patch fixes to work around broken mktime() in recent glibc
    	releases.
    
    2002-09-30 16:47  tgl
    
    	* src/backend/: commands/async.c, tcop/postgres.c (REL7_2_STABLE):
    	Back-patch fix for bad SIGUSR2 interrupt handling during backend
    	shutdown.
    
    2002-09-30 16:24  tgl
    
    	* src/: backend/storage/lmgr/s_lock.c, include/storage/s_lock.h
    	(REL7_2_STABLE): Back-patch fix for correct TAS operation on
    	multi-CPU PPC machines.
    
    2002-09-30 16:18  tgl
    
    	* src/backend/: bootstrap/bootstrap.c, storage/buffer/buf_init.c,
    	storage/lmgr/lwlock.c, storage/lmgr/proc.c (REL7_2_STABLE):
    	Back-patch fix for 'can't wait without a PROC structure' failures:
    	remove separate ShutdownBufferPoolAccess exit callback, and do the
    	work in ProcKill instead, before we delete MyProc.
    
    2002-09-30 15:55  tgl
    
    	* src/: backend/access/transam/clog.c,
    	backend/access/transam/xlog.c, backend/bootstrap/bootstrap.c,
    	backend/tcop/utility.c, include/access/xlog.h (REL7_2_STABLE):
    	Back-patch fix to ensure a checkpoint occurs before truncating
    	CLOG, even if no recent WAL activity has occurred.
    
    2002-09-30 15:45  tgl
    
    	* src/backend/commands/vacuum.c (REL7_2_STABLE): Back-patch fix to
    	not change pg_database.datvacuumxid or truncate CLOG when an
    	unprivileged user runs VACUUM.
    
    2002-09-20 17:37  tgl
    
    	* src/backend/utils/adt/ruleutils.c (REL7_2_STABLE): Back-patch fix
    	for failure to dump views containing FULL JOIN USING.  The bug is
    	not present in CVS tip due to cleanup of JOIN handling, but 7.2.*
    	is broken.
    
    
  2. Re: 7.2.3 patching done

    Bruce Momjian <pgman@candle.pha.pa.us> — 2002-10-01T03:35:41Z

    OK, 7.2.3 is all branded and ready to go.  HISTORY/release.sgml shows:
    
    ---------------------------------------------------------------------------
    
    
                                     Release Notes
    
    
                                     Release 7.2.3
    
         Release date: 2002-10-01
    
       This has a variety of fixes from 7.2.2, including fixes to prevent
       possible data loss.
    
         ----------------------------------------------------------------------
    
    Migration to version 7.2.3
    
       A dump/restore is *not* required for those running 7.2.X.
    
         ----------------------------------------------------------------------
    
    Changes
    
     Prevent possible compressed transaction log loss (Tom)
     Prevent non-superuser from increasing most recent vacuum info (Tom)
     Handle pre-1970 date values in newer versions of glibc (Tom)
     Fix possible hang during server shutdown
     Prevent spinlock hangs on SMP PPC machines (Tomoyuki Niijima)
     Fix pg_dump to properly dump FULL JOIN USING (Tom)
    
    
    ---------------------------------------------------------------------------
    
    Tom Lane wrote:
    > I'm done making back-patches for 7.2.3.  Over to you, Bruce ...
    > attached is the REL7_2_STABLE branch history since 7.2.2.
    > 
    > 			regards, tom lane
    > 
    > 2002-09-30 16:57  tgl
    > 
    > 	* src/backend/utils/adt/: date.c, datetime.c (REL7_2_STABLE):
    > 	Back-patch fixes to work around broken mktime() in recent glibc
    > 	releases.
    > 
    > 2002-09-30 16:47  tgl
    > 
    > 	* src/backend/: commands/async.c, tcop/postgres.c (REL7_2_STABLE):
    > 	Back-patch fix for bad SIGUSR2 interrupt handling during backend
    > 	shutdown.
    > 
    > 2002-09-30 16:24  tgl
    > 
    > 	* src/: backend/storage/lmgr/s_lock.c, include/storage/s_lock.h
    > 	(REL7_2_STABLE): Back-patch fix for correct TAS operation on
    > 	multi-CPU PPC machines.
    > 
    > 2002-09-30 16:18  tgl
    > 
    > 	* src/backend/: bootstrap/bootstrap.c, storage/buffer/buf_init.c,
    > 	storage/lmgr/lwlock.c, storage/lmgr/proc.c (REL7_2_STABLE):
    > 	Back-patch fix for 'can't wait without a PROC structure' failures:
    > 	remove separate ShutdownBufferPoolAccess exit callback, and do the
    > 	work in ProcKill instead, before we delete MyProc.
    > 
    > 2002-09-30 15:55  tgl
    > 
    > 	* src/: backend/access/transam/clog.c,
    > 	backend/access/transam/xlog.c, backend/bootstrap/bootstrap.c,
    > 	backend/tcop/utility.c, include/access/xlog.h (REL7_2_STABLE):
    > 	Back-patch fix to ensure a checkpoint occurs before truncating
    > 	CLOG, even if no recent WAL activity has occurred.
    > 
    > 2002-09-30 15:45  tgl
    > 
    > 	* src/backend/commands/vacuum.c (REL7_2_STABLE): Back-patch fix to
    > 	not change pg_database.datvacuumxid or truncate CLOG when an
    > 	unprivileged user runs VACUUM.
    > 
    > 2002-09-20 17:37  tgl
    > 
    > 	* src/backend/utils/adt/ruleutils.c (REL7_2_STABLE): Back-patch fix
    > 	for failure to dump views containing FULL JOIN USING.  The bug is
    > 	not present in CVS tip due to cleanup of JOIN handling, but 7.2.*
    > 	is broken.
    > 
    
    -- 
      Bruce Momjian                        |  http://candle.pha.pa.us
      pgman@candle.pha.pa.us               |  (610) 359-1001
      +  If your life is a hard drive,     |  13 Roberts Road
      +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073
    
    
  3. Re: 7.2.3 patching done

    Yury Bokhoncovich <byg@center-f1.ru> — 2002-10-01T08:01:08Z

    Hello!
    
    BTW, is it possible to have just patch against previous version (to reduce 
    traffic and CPU)? I.e. something like 7.2.2-7.2.3.diff.gz?
    
    -- 
    WBR, Yury Bokhoncovich, Senior System Administrator, NOC of F1 Group.
    Phone: +7 (3832) 106228, ext.140, E-mail: byg@center-f1.ru.
    Unix is like a wigwam -- no Gates, no Windows, and an Apache inside.
    
    
    
    
  4. Re: 7.2.3 patching done

    Bruce Momjian <pgman@candle.pha.pa.us> — 2002-10-01T15:17:16Z

    Yury Bokhoncovich wrote:
    > Hello!
    > 
    > BTW, is it possible to have just patch against previous version (to reduce 
    > traffic and CPU)? I.e. something like 7.2.2-7.2.3.diff.gz?
    
    In some releases, it is possible, in others we add/remove files and it
    isn't possible.  I think because it isn't always possible we normally
    don't do it.
    
    -- 
      Bruce Momjian                        |  http://candle.pha.pa.us
      pgman@candle.pha.pa.us               |  (610) 359-1001
      +  If your life is a hard drive,     |  13 Roberts Road
      +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073
    
    
  5. Re: 7.2.3 patching done

    Peter Eisentraut <peter_e@gmx.net> — 2002-10-01T20:04:04Z

    Bruce Momjian writes:
    
    > > BTW, is it possible to have just patch against previous version (to reduce
    > > traffic and CPU)? I.e. something like 7.2.2-7.2.3.diff.gz?
    >
    > In some releases, it is possible, in others we add/remove files and it
    > isn't possible.  I think because it isn't always possible we normally
    > don't do it.
    
    Adding or removing files isn't the problem (see -N option).  Binary files
    are the problem.
    
    Using xdelta would be safe, though.
    
    -- 
    Peter Eisentraut   peter_e@gmx.net
    
    
    
  6. Re: 7.2.3 patching done

    Bruce Momjian <pgman@candle.pha.pa.us> — 2002-10-01T20:08:24Z

    Peter Eisentraut wrote:
    > Bruce Momjian writes:
    > 
    > > > BTW, is it possible to have just patch against previous version (to reduce
    > > > traffic and CPU)? I.e. something like 7.2.2-7.2.3.diff.gz?
    > >
    > > In some releases, it is possible, in others we add/remove files and it
    > > isn't possible.  I think because it isn't always possible we normally
    > > don't do it.
    > 
    > Adding or removing files isn't the problem (see -N option).  Binary files
    > are the problem.
    
    Do we change any binary files in minor releases, or even major ones?
    
    -- 
      Bruce Momjian                        |  http://candle.pha.pa.us
      pgman@candle.pha.pa.us               |  (610) 359-1001
      +  If your life is a hard drive,     |  13 Roberts Road
      +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073
    
    
  7. Re: 7.2.3 patching done

    Tom Lane <tgl@sss.pgh.pa.us> — 2002-10-01T20:12:09Z

    Bruce Momjian <pgman@candle.pha.pa.us> writes:
    > Peter Eisentraut wrote:
    >> Adding or removing files isn't the problem (see -N option).  Binary files
    >> are the problem.
    
    > Do we change any binary files in minor releases, or even major ones?
    
    But the source distribution hasn't *got* any binary files.
    
    			regards, tom lane
    
    
  8. Re: 7.2.3 patching done

    Bruce Momjian <pgman@candle.pha.pa.us> — 2002-10-01T22:10:57Z

    Tom Lane wrote:
    > Bruce Momjian <pgman@candle.pha.pa.us> writes:
    > > Peter Eisentraut wrote:
    > >> Adding or removing files isn't the problem (see -N option).  Binary files
    > >> are the problem.
    > 
    > > Do we change any binary files in minor releases, or even major ones?
    > 
    > But the source distribution hasn't *got* any binary files.
    
    Yea, that was sort of my point.
    
    -- 
      Bruce Momjian                        |  http://candle.pha.pa.us
      pgman@candle.pha.pa.us               |  (610) 359-1001
      +  If your life is a hard drive,     |  13 Roberts Road
      +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073
    
    
  9. Re: 7.2.3 patching done

    Yury Bokhoncovich <byg@center-f1.ru> — 2002-10-02T01:57:45Z

    Hello!
    
    On Tue, 1 Oct 2002, Bruce Momjian wrote:
    
    > In some releases, it is possible, in others we add/remove files and it
    > isn't possible.  I think because it isn't always possible we normally
    > don't do it.
    
    I think it's enough to do diffs for minor release (i.e. 7.2.2->7.2.3, 
    7.3.0->7.3.1 and so on). BTW, I had no problems with patching Linux kernel 
    this way (e.g. having vanilla 2.2.16 then sequentially patch for 2.2.17, 
    .18, .19, .20, .21, .22) though there were added directories.
    
    -- 
    WBR, Yury Bokhoncovich, Senior System Administrator, NOC of F1 Group.
    Phone: +7 (3832) 106228, ext.140, E-mail: byg@center-f1.ru.
    Unix is like a wigwam -- no Gates, no Windows, and an Apache inside.
    
    
    
    
  10. Re: 7.2.3 patching done

    Peter Eisentraut <peter_e@gmx.net> — 2002-10-07T19:22:38Z

    Tom Lane writes:
    
    > But the source distribution hasn't *got* any binary files.
    
    There are some under doc/src/graphics, and then there are
    doc/postgres.tar.gz and doc/man.tar.gz.
    
    -- 
    Peter Eisentraut   peter_e@gmx.net
    
    
    
  11. Re: 7.2.3 patching done

    Alvaro Herrera <alvherre@dcc.uchile.cl> — 2002-10-07T21:45:57Z

    On Mon, Oct 07, 2002 at 09:22:38PM +0200, Peter Eisentraut wrote:
    > Tom Lane writes:
    > 
    > > But the source distribution hasn't *got* any binary files.
    > 
    > There are some under doc/src/graphics, and then there are
    > doc/postgres.tar.gz and doc/man.tar.gz.
    
    And what about publishing xdelta patches?
    
    -- 
    Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
    "Escucha y olvidarás; ve y recordarás; haz y entenderás" (Confucio)