Trying to load a 6 January pg_dumpall file with today's postgresql gives
many
invalid command \N
probably because
PQexec: you gotta get out of a COPY state yourself.
db.out4:11621: invalid command \.
Somehow psql is out of sync and thinks the \N isn't within a COPY block.
The work around was to redump as insert statements..
It's tricky (for me) to debug as "stdin;" file not found..
How do you get of a COPY state yourself?
Cheers,
Patrick