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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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. ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly