Re: [HACKERS] pg_upgrade: What is changed?

2006-08-28 Thread Zdenek Kotala
Zdenek Kotala napsal(a): Martijn van Oosterhout wrote: On Wed, Aug 23, 2006 at 10:26:19AM +0200, Zdenek Kotala wrote: 5) Tuples question: Does have data types some disk representation? Does have tupleheader same structure? I think only the inet/cidr types changed format

Re: [HACKERS] pg_upgrade: What is changed?

2006-08-24 Thread Zdenek Kotala
Jim C. Nasby wrote: On Wed, Aug 23, 2006 at 10:49:05AM +0200, Martijn van Oosterhout wrote: 8) WAL/XLOG Question: Should be deleted? I imagine you should probably force a checkpoint and then wipe the wal records. The WAL isn't going to be able to cover some of the stuff done during the upgr

Re: [HACKERS] pg_upgrade: What is changed?

2006-08-24 Thread Jim C. Nasby
On Wed, Aug 23, 2006 at 10:49:05AM +0200, Martijn van Oosterhout wrote: > > 8) WAL/XLOG > > Question: Should be deleted? > > I imagine you should probably force a checkpoint and then wipe the wal > records. The WAL isn't going to be able to cover some of the stuff done > during the upgrade, so

Re: [HACKERS] pg_upgrade: What is changed?

2006-08-23 Thread Alvaro Herrera
Zdenek Kotala wrote: > Martijn van Oosterhout wrote: > >On Wed, Aug 23, 2006 at 10:26:19AM +0200, Zdenek Kotala wrote: > > > > > > > >>1) BKI - catalog. > >> c) Some records are changed > >> action: ??? > > > >They just need to be changed. In principle the datalog needs to be > >updated so

Re: [HACKERS] pg_upgrade: What is changed?

2006-08-23 Thread Zdenek Kotala
Martijn van Oosterhout wrote: On Wed, Aug 23, 2006 at 10:26:19AM +0200, Zdenek Kotala wrote: 1) BKI - catalog. c) Some records are changed action: ??? They just need to be changed. In principle the datalog needs to be updated so it looks like a database initdb'd with the new versi

Re: [HACKERS] pg_upgrade: What is changed?

2006-08-23 Thread Martijn van Oosterhout
On Wed, Aug 23, 2006 at 10:26:19AM +0200, Zdenek Kotala wrote: > 1) BKI - catalog. >c) Some records are changed >action: ??? They just need to be changed. In principle the datalog needs to be updated so it looks like a database initdb'd with the new version. > 5) Tuples > ques

[HACKERS] pg_upgrade: What is changed?

2006-08-23 Thread Zdenek Kotala
I'm working on pg_upgrade concept. I try to determine what is changed from 8.1 to 8.2. There is list of important areas for upgrade and suggested action. 1) BKI - catalog. There are a lot of changes. See attached file. a) There is new table pg_shdescription action: create b) T