Re: pg_restore peculiarities

"Michael Paesold" <mpaesold@gmx.at> 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 included with the package and selected for
> install (at the module selection screen)... the default is to install all.

> I would rather like the installer to only install the dlls etc. and not
> throw everything into template1... perhaps add a feature request at
> pgFoundry?

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.

            regards, tom lane