Kenneth Marshall <ktm at rice.edu> writes:
> In particular, I would like to be able to upgrade an
> 8.3 databae to 8.4 with minimal downtime. 1.2.14 does
> not build with a missing function definition for
> SerializableSnapshot. If not, is there a scheme to
> upgrade to 8.4 that does not entail the outage of
> a full dump/restore cycle?

No, 1.2 does not work with 8.4, and barring having considerably more
time to play with, it doesn't seem like a straightforward backport.

There were substantial changes in 8.4 to the implementation of
pg_listener, to change from on-table storage to an in-memory handling
that would fairly much break the whole listener loop.

Version 2.0 revised that substantially; that doesn't seem like a
backport, though.
-- 
(reverse (concatenate 'string "ofni.sailifa.ac" "@" "enworbbc"))
<http://dba2.int.libertyrms.com/>
Christopher Browne
(416) 673-4124 (land)
"Adding more frammishes to the manual commands seems like gilding the
buggy whip."  -- Tom Lane