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@xxxxxxxxx> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to litigate.
Attachment:
signature.asc
Description: Digital signature
