> "Thomas H." <me@alternize.com> writes:
>> what is the proper method to restore data from a previous named database
>> =
>> "olddb" into a fresh database named "newdb"? the old database still =
>> exists and i don't want to overwrite the data.
>
> Create newdb by hand and then specify it as the connection target for
> pg_restore. *Don't* use --create, as that tells pg_restore to create
> and (re)connect to the database named in the dump.
i see.
but then failures will pop up: when creating a new db, it already contains
the system languages, functions and tables (for example tsearch2). as the
dump contains these as well, i'm getting lots of errors and more important,
tsearch2 custom config won't be restored.
how can i create an *empty* database?
- thomas
