Re: pg_restore problems

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(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of Martijn van
Oosterhout
Sent: August 28, 2006 7:50 AM
To: Bobby Gontarski
Cc: pgsql-general(at)postgresql(dot)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(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to
litigate.