X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 2FB2ED1C513 for ; Tue, 17 Feb 2004 02:59:15 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 83541-07 for ; Mon, 16 Feb 2004 22:59:15 -0400 (AST) Received: from hotmail.com (bay1-f35.bay1.hotmail.com [65.54.245.35]) by svr1.postgresql.org (Postfix) with ESMTP id 1FD85D1B49E for ; Mon, 16 Feb 2004 22:59:11 -0400 (AST) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Mon, 16 Feb 2004 18:59:15 -0800 Received: from 156.34.61.254 by by1fd.bay1.hotmail.msn.com with HTTP; Tue, 17 Feb 2004 02:59:15 GMT X-Originating-IP: [156.34.61.254] X-Originating-Email: [temp6453@hotmail.com] X-Sender: temp6453@hotmail.com From: "Mike Miller" To: pgsql-admin@postgresql.org Subject: Restoring pg_dump's made using COPY commands Date: Tue, 17 Feb 2004 02:59:15 +0000 Mime-Version: 1.0 Content-Type: text/plain; format=flowed Message-ID: X-OriginalArrivalTime: 17 Feb 2004 02:59:15.0383 (UTC) FILETIME=[07117470:01C3F502] X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/249 X-Sequence-Number: 12423 Hi, I'm trying to restore two dumps, one from 7.1.3 and the other from a 6.5.3 series PgSQL server. These dumps were both made using standard 'pg_dump > output' commands (specifying the host where needed on one of them). When I run the database restore by doing execute-file in psql, piping the file to psql, or even attempting pg_restore (whcih doesn't work on these plain text databases), I receive messages pertaining to: invalid command \N invalid command \. parse error at the end of line However this dump just came from a pg_dump, so it really should be working. I've tried every combination of pg_dump and psql versions from 7.4.1, 7.3.3, 7.1.3, 6.5.3 in order to get this to work right without any luck. Can anyone help me out with what is wrong? I'm looking to make this a backup method, and if I can't restore the data, it doesn't do me much good (and I'm trying to restore some existing data). Ultimately want to move them all up to 7.4.x Any ideas as to what causes these errors? Anything I can do to fix the output of pg_dump? Thanks! -Mike _________________________________________________________________ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus&pgmarket=en-ca&RU=http%3a%2f%2fjoin.msn.com%2f%3fpage%3dmisc%2fspecialoffers%26pgmarket%3den-ca