Tom Lane wrote:
Without taking a position on what the Windows installer ought to do ...
*whenever* you are restoring a pg_dump dump, you ought to do so into
an empty database cloned from template0. If the documentation doesn't
say that in enough places, suggest some more.
Right. If, as Tom say
"Michael Paesold" <[EMAIL PROTECTED]> writes:
> Tim Penhey wrote:
>> The only thing it asked in the installer was what languages to add to
>> the template, and I chose plpgsql only.
> I also thought so, but it's not the case. The installer puts all contrib
> modules into template1 that are include
Tim Penhey wrote:
> Which does bring another question forward:
>
> What is all the stuff that has been added to template1 given it is a
> clean install of version 8 beta 2 dev 3?
>
> The only thing it asked in the installer was what languages to add to
> the template, and I chose plpgsql only.
I
Tom Lane wrote:
It looks to me like you have a bunch of stuff in template1, which is
being duplicated into your test_restored DB and then is interfering
with the restoration of similarly-named objects.
Create the empty database using template0 as template, instead, and
then the restore will work.
