Horton

Thread

  1. pg_dumpall

    Andrew Martin <martin@biochemistry.ucl.ac.uk> — 1998-03-06T16:45:15Z

    I've dumped a 6.1 database using the pg_dumpall from 6.3 to load into
6.3.

The format of the data to be copied into pg_user is wrong - there are
not enough columns. I guess this may be a problem from having skipped
out 6.2, but it would be nice if it worked properly :-)

Also one of the column names I had used in my old database is no longer
allowed ('local'). Again, it would be nice if pg_dumpall could spot
no-longer allowed column names and warn the user rather than having
psql crash when one tries to import the data and then having to trace
back to where the problem was...


Best wishes,

Andrew
----------------------------------------------------------------------------
Dr. Andrew C.R. Martin                             University College London
EMAIL: (Work) martin@biochem.ucl.ac.uk    (Home) andrew@stagleys.demon.co.uk
URL:   http://www.biochem.ucl.ac.uk/~martin
Tel:   (Work) +44(0)171 419 3890                    (Home) +44(0)1372 275775