Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
have pg_restore create a new database?
- From: "Thomas H." <me(at)alternize(dot)com>
- To: <pgsql-general(at)postgresql(dot)org>
- Subject: have pg_restore create a new database?
- Date: Sun, 26 Nov 2006 14:18:32 +0100
- Message-id: <08ec01c7115d$5fb8dd50$0201a8c0(at)iwing>
|
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
|
- Follow-Ups:
- Re: have pg_restore create a new database?
- From: Tom Lane
- Re: have pg_restore create a new database?
- Prev by Date: Re: PGDATA
- Next by Date: Re: have pg_restore create a new database?
- Previous by thread: Clone all user defined triggers in schema
- Next by thread: Re: have pg_restore create a new database?
- Indexes: