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 says, that restores should be into an empty database
cloned form template0, what then is the best way to provide a data
restore facility to a user though a back end system (Tomcat & JDBC) that
will have connections open to the database that you are trying to
restore to?
Tim