Re: pg_restore peculiarities - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_restore peculiarities
Date
Msg-id 10270.1095543582@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_restore peculiarities  ("Michael Paesold" <mpaesold@gmx.at>)
Responses Re: pg_restore peculiarities  (Tim Penhey <tim@penhey.net>)
List pgsql-general
"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

pgsql-general by date:

Previous
From: "Michael Paesold"
Date:
Subject: Re: pg_restore peculiarities
Next
From: Tim Penhey
Date:
Subject: Re: pg_restore peculiarities