I have setup a new server to hold my postgres 8.1 database.
when i do a pg_dump to a file mydb.tar where to i copy it to on the new
server to restore it
also will all the schemas be copied also
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Martijn van
Oosterhout
Sent: August 28, 2006 7:50 AM
To: Bobby Gontarski
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] pg_restore problems
On Mon, Aug 28, 2006 at 02:38:07PM +0200, Bobby Gontarski wrote:
> I do:
> pg_dump -Ft mydb > mydb.tar
> pg_restore -d newdb mydb.tar
> and I get tuns of errors. Like:
> pg_restore: [archiv?? (db)] could not execute query: ERROR: relation
"pg_ts_cfg map" already exists
<Snip>
Normally you restore onto a system that doesn't have the database
already. Obviously if you try to do that you'll get messages saying the
tables already exist.
You can ask for pg_restore to drop the tables before restoring them,
but for obvious reasons this is not the default.
Have anice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to
litigate.
