Re: have pg_restore create a new database?

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

"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