i'm trying to have pg_restore create a new db and
load the data.
unfortunately, pg_restore always uses the database
name specified in the dump. "--create" and "--dbname=newdb" does not seem to
have any effect (pg_restore yells about database being non-existant).
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.
regards,
thomas
|