From: | Magnus Hagander <mha(at)sollentuna(dot)net> |
---|---|
To: | Magnus Hagander <mha(at)sollentuna(dot)net>, "'Peter Eisentraut'" <peter_e(at)gmx(dot)net> |
Cc: | "'pgsql-hackers(at)postgresql(dot)org'" <pgsql-hackers(at)postgreSQL(dot)org> |
Subject: | RE: [HACKERS] Minor problems reloading dump in 7.0beta1 |
Date: | 2000-02-24 15:55:37 |
Message-ID: | 215896B6B5E1CF11BC5600805FFEA82103045C00@sirius.edu.sollentuna.se |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> > > 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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-02-24 15:56:12 | Re: [HACKERS] Re: [BUGS] First experiences with Postgresql 7.0 |
Previous Message | Bruce Momjian | 2000-02-24 15:49:16 | Re: [HACKERS] 7.0beta1 on Win32 |