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

[GENERAL] 8.0 rc2 Problem

2004-12-26 Thread Peter Childs
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 files to somewhere then prin