Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 19C202E0052 for ; Thu, 17 Apr 2008 07:36:58 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 32370-05 for ; Thu, 17 Apr 2008 07:36:37 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mail.mobilefundas.com (208.76.244.51.reverse.crucialx.net [208.76.244.51]) by developer.postgresql.org (Postfix) with ESMTP id 1BEA02E006E for ; Thu, 17 Apr 2008 07:36:36 -0300 (ADT) Received: (qmail 16993 invoked by uid 89); 17 Apr 2008 10:36:34 -0000 Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=private; d=mobilefundas.com; b=IykJQgSaBP16eZwvxQINkw4z04yL+kYcXau79YshgNRdzhGw4kHb8bkMWrbjo5vo; Received: by simscan 1.3.1 ppid: 16898, pid: 16964, t: 0.3638s scanners: attach: 1.3.1 clamav: 0.92.1 /m: 45 Received: from unknown (HELO ?121.247.164.219?) (dipesh.mistry@mobilefundas.com@121.247.164.219) by mail.mobilefundas.com with ESMTPA; 17 Apr 2008 10:36:33 -0000 Message-ID: <48072899.3080102@mobilefundas.com> Date: Thu, 17 Apr 2008 16:08:17 +0530 From: dipesh User-Agent: Thunderbird 1.5.0.12 (X11/20071020) MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Error in restore the Database in Postgres Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.205 tagged_above=0 required=5 tests=AWL=-1.129, DEAR_SOMETHING=2.234, RDNS_DYNAMIC=0.1 X-Spam-Level: * X-Archive-Number: 200804/113 X-Sequence-Number: 30652 Dear Sir, I have Mysql database backup file ( xyz.sql ). Now i want to restore this ( xyz.sql ) file into Postgres Database. I try following command to restore but Postgres gives me the Error. psql -d tracker -f /home/postgres/backup/tracker_db.sql In xyz.sql file Lock Table; statement is written on each table. I use Postgres 8.1 version. Kindly Help me as early as possible. Or, give me another command. -- With Warm Regards, Dipesh Mistry Information Technology Dept. GaneshaSpeaks.com