"Thomas H." <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq