Re: [GENERAL] 8.0 rc2 Problem

2004-12-28 Thread Tom Lane
Peter Childs <[EMAIL PROTECTED]> writes: > Further examination I orignally used by 7.4 backup (taken > every 12 hours and well tested that they work under 7.4 anyway) rather > than redumping using pg_dump 8.0. I have now dumped using pg_dump version > 8.0 same problem. I dumped just the s

Re: [GENERAL] 8.0 rc2 Problem

2004-12-28 Thread Peter Childs
On Mon, 27 Dec 2004, Peter Childs wrote: > Tom Lane wrote: > > >Peter Childs <[EMAIL PROTECTED]> writes: > > > > > >>2. I loaded out 7.4 database on via a dump and reload. Once done I keep > >>getting errors when it trys to analyse (I'm using autovacuum) Nothing > >>unsuall just a straght forwar

Re: [GENERAL] 8.0 rc2 Problem

2004-12-27 Thread Bruce Momjian
Peter Childs wrote: > Right just installed rc2 to test so that we can use 8.0 once its > out. Loads of nice features, Nice to see them all. Postgres 8.0 seams > faster, but this might be due to the reload. Oh the point in time > recovery feature are there any example scripts to say copy the

Re: [GENERAL] 8.0 rc2 Problem

2004-12-27 Thread Peter Childs
Tom Lane wrote: Peter Childs <[EMAIL PROTECTED]> writes: 2. I loaded out 7.4 database on via a dump and reload. Once done I keep getting errors when it trys to analyse (I'm using autovacuum) Nothing unsuall just a straght forward pg_dump from 7.4 loaded into 8.0. Dec 27 07:34:45 ex37 p

Re: [GENERAL] 8.0 rc2 Problem

2004-12-27 Thread Tom Lane
Peter Childs <[EMAIL PROTECTED]> writes: > 2. I loaded out 7.4 database on via a dump and reload. Once done I keep > getting errors when it trys to analyse (I'm using autovacuum) Nothing > unsuall just a straght forward pg_dump from 7.4 loaded into 8.0. > Dec 27 07:34:45 ex37 postgres[5745]: [28