7.2.3 patching done

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

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.

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

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

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

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

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

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.

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

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)