Re: [GENERAL] Waarschuwing na pg_dumpall en restore

2010-06-25 Thread Alvaro Herrera
Excerpts from Dick Kniep's message of vie jun 25 04:54:15 -0400 2010: > PROBLEM 2 > >   > > Furthermore the following errors are shown: > >   > > psql:db03.ak1.sql:251166: ERROR:  column a.transaction does not exist > LINE 2: SELECT (a.relation)::regclass AS "table", a."transaction... >   

Re: [GENERAL] Waarschuwing na pg_dumpall en restore

2010-06-25 Thread Alban Hertroys
On 25 Jun 2010, at 10:54, Dick Kniep wrote: > Hi List, > > Thanks for this great product. > > We have a database with many schema's and we are trying to migrate the db > from version 8.1.9 to 8.3.8. > > So we made a pg_dumpall. Using which version? The one that came with 8.3? I'm suspectin

[GENERAL] Waarschuwing na pg_dumpall en restore

2010-06-25 Thread Dick Kniep
Hi List,   Thanks for this great product.   We have a database with many schema's and we are trying to migrate the db from version 8.1.9 to 8.3.8.   So we made a pg_dumpall.   Now, when we try to restore with psql, we get loads of errors and warnings: PROBLEM 1   psql:db03.ak1.sql:101