Re: 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.