"Thomas H." <me@xxxxxxxxxxxxx> 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
