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