X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 3290A329DE0 for ; Fri, 10 Sep 2004 14:06:05 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 58600-09 for ; Fri, 10 Sep 2004 13:05:56 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id D3703329DD0 for ; Fri, 10 Sep 2004 14:05:59 +0100 (BST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i8AD5sCn062923 for ; Fri, 10 Sep 2004 13:05:54 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i8ACpnd8057454 for pgsql-admin@postgresql.org; Fri, 10 Sep 2004 12:51:49 GMT From: spraveen2001@yahoo.com (Praveen) X-Newsgroups: comp.databases.postgresql.admin Subject: DB Export and Import in PGSQL Date: 10 Sep 2004 05:51:52 -0700 Organization: http://groups.google.com Lines: 16 Message-ID: <98d8ec76.0409100451.1840ca9b@posting.google.com> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: groups-abuse@google.com To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.3 tagged_above=0.0 required=5.0 tests=FORGED_YAHOO_RCVD, FROM_ENDS_IN_NUMS X-Spam-Level: * X-Archive-Number: 200409/103 X-Sequence-Number: 14806 Hi All, I'm using PGSql 7.4.3 on win2k system. i have a small db with some tables,indexes,sequences,constraints and data. Today i took the export(pg_dump) of my db and try to import(psql) in different new database. The following command i used: psql mydb < mybackfile.bkp It is successfully able to import table,sequence,indexes,constraints but data is not able to import. means, i'm not able to see my data. Can anyone tell what might be the problem? Thanks, Praveen