-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 01/27/07 00:19, Martijn van Oosterhout wrote:
> On Fri, Jan 26, 2007 at 10:16:39PM -0600, Ron Johnson wrote:
>> What are your plans for reducing the number of resources needed to
>> upgrade databases?
>
> As noted, the table structure changes only
On Fri, Jan 26, 2007 at 10:16:39PM -0600, Ron Johnson wrote:
> What are your plans for reducing the number of resources needed to
> upgrade databases?
As noted, the table structure changes only slightly between versions,
if at all. What does change significantly is the catalog. Even now
there have
1. Cleanly shutdown pg.
2. Install v8.2.
3. Start pg.
4. psql -c 'REINDEX DATABASE' some_db
>>> The changes are usually very subtle, like changes in the storage format
>>> for certain data types, or bit changes in the row headers --- it isn't
>>> something really of interest ex
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 01/26/07 21:48, Bruce Momjian wrote:
> Ron Johnson wrote:
>>> Yes:
>>>
>>> http://www.postgresql.org/docs/8.2/static/migration.html
>> I was thinking of something like the release notes, but a bit more
>> targeted. (I know. diff the source.)
>
Ron Johnson wrote:
> > Yes:
> >
> > http://www.postgresql.org/docs/8.2/static/migration.html
>
> I was thinking of something like the release notes, but a bit more
> targeted. (I know. diff the source.)
>
> http://www.postgresql.org/docs/8.2/interactive/release-8-2.html
>
> For example, I
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 01/26/07 20:12, Bruce Momjian wrote:
> Ron Johnson wrote:
>>> There is no set time frame planned that I know of.
>>>
>>> It is more a matter of users that keep the old versions alive. Some with
>>> large datasets on busy servers that can't allocate
Ron Johnson wrote:
> > There is no set time frame planned that I know of.
> >
> > It is more a matter of users that keep the old versions alive. Some with
> > large datasets on busy servers that can't allocate enough downtime to
> > upgrade tend to be keeping the older versions running.
>
> How m
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 01/26/07 17:28, Shane Ambler wrote:
> Bill Moran wrote:
>> I spend some time googling this and searching the Postgresql.org site,
>> but
>> I'm either not good enough with the search strings, or it's not to be
>> found.
>>
>> I'm trying to plan upgr
