Re: [HACKERS] [patch] pg_upgrade script for 8.3-8.4

2008-12-05 Thread Greg Smith
On Thu, 4 Dec 2008, Zdenek Kotala wrote: 1) Keep relfileid of toast file same. It is important because toast pointer contains relfileid. Currently script creates fake files with same number to protect postgresql to create new relation with this refileid. It works but by my opinion it is not

Re: [HACKERS] [patch] pg_upgrade script for 8.3-8.4

2008-12-05 Thread Zdenek Kotala
Greg Smith napsal(a): On Thu, 4 Dec 2008, Zdenek Kotala wrote: 1) Keep relfileid of toast file same. It is important because toast pointer contains relfileid. Currently script creates fake files with same number to protect postgresql to create new relation with this refileid. It works but by

[HACKERS] [patch] pg_upgrade script for 8.3-8.4

2008-12-04 Thread Zdenek Kotala
Hi all, I attached pg_upgrade.sh script patch which works now for 8.3-8.4. It is contrib module in contrib/pg_upgrade directory. Just make/make install and it works. There are two changes from previous 8.1-8.2. 1) pg_largeobject is also upgraded 2) added check for dropped column And now how

Re: [HACKERS] [patch] pg_upgrade script for 8.3-8.4

2008-12-04 Thread David Fetter
On Thu, Dec 04, 2008 at 05:57:01PM +0100, Zdenek Kotala wrote: Hi all, I attached pg_upgrade.sh script patch which works now for 8.3-8.4. It is contrib module in contrib/pg_upgrade directory. Just make/make install and it works. Kudos! 4) script is written in ksh. It has several

Re: [HACKERS] [patch] pg_upgrade script for 8.3-8.4

2008-12-04 Thread Zdenek Kotala
Zdenek Kotala napsal(a): Hi all, I attached pg_upgrade.sh script patch which works now for 8.3-8.4. It is contrib module in contrib/pg_upgrade directory. Just make/make install and it works. I forget to mention that default datetime format is different now. Please, use same datetime format