> > > The dump works fine if I start psql and use \i to load it. 
> > (I reliase
> > > the documentation says use "psql < filename", but I 
> didn't read that
> > > far :-)
> > 
> > ... makes this look like a really weird bug. What's the 
> > connect statement,
> > and what's the error message? (It better not abort without one. ;)
> 
> First it was:
> \connect template1
> 
> Noticing it was not like the statements further down in the 
> file, I changed
> it to:
> \connect template1 postgres
> 
> It dies with:
> psql: FATAL 1:  Database "postgres" does not exist in the 
> system catalog.
> 
> Same error message in both cases.

Ok. Kill me. I know the problem - user error.
I forgot to enter which database psql should connect to first. So it tried
'postgres', since 'postgres' was the user I was logged in as.
Stupid.

Sorry about this one.

//Magnus

Thu, 24 Feb 2000 16:55:37 +0100
Magnus Hagander <mha@sollentuna.net>
RE: [HACKERS] Minor problems reloading dump in 7.0beta1