"Thomas H." <me(at)alternize(dot)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.
regards, tom lane