I had some trouble reading in my "pg_dumpall -o" from 6.3.2 into 6.4.2,
and am sending this out to document the solution in the email archives.
My search of the pgsql-admin archives came up empty on this problem,
though I'm sure to more experienced PGSQL'ers it will seem simple. It
would be great to get something about these problems into the FAQ or
somewhere.
I was getting a lot of errors early on when trying to read pg_dumpall
back in via psql ... it turned out it doesn't work to do it as a user
other than postgres. I thought that since I had user access it would
work, but it failed very quickly. But running as user postgres solved
it.
The derailing event looked like this:
drop table tmp_pg_shadow;
QUERY: drop table tmp_pg_shadow;
ERROR: pg_ownercheck: user "michael" not found
Another conversion problem I hit was a table got output with varchar(-5)
field definitions, which I had to fix by hand.
A third problem was that some or all dates were output with
'/etc/localtime' text (sic) instead of PST or something... again, fixed
by hand.
Although these may seem simple, it would be great to incorporate this
info into the FAQ or documentation somewhere for others who hit the same
problems I did.
--Michael
