Received: from pmesmtp01.wcom.com (pmesmtp01.wcom.com [199.249.20.1]) by postgresql.org (Postfix) with ESMTP id E4DAC476050 for ; Thu, 7 Mar 2002 12:21:09 -0500 (EST) Received: from CONVERSION-DAEMON by firewall.wcom.com (PMDF V5.2-33 #47837) id <0GSM00F015IEVF@firewall.wcom.com> for pgsql-admin@postgresql.org; Thu, 7 Mar 2002 17:20:38 +0000 (GMT) Received: from dgismtp01.wcomnet.com ([166.38.58.141]) by firewall.wcom.com (PMDF V5.2-33 #47837) with ESMTP id <0GSM00E7R5IESB@firewall.wcom.com>; Thu, 07 Mar 2002 17:20:38 +0000 (GMT) Received: from dgismtp01.wcomnet.com by dgismtp01.wcomnet.com (PMDF V5.2-33 #42262) with SMTP id <0GSM00B015HY4C@dgismtp01.wcomnet.com>; Thu, 07 Mar 2002 17:20:38 +0000 (GMT) Received: from wcom.com ([159.98.137.234]) by dgismtp01.wcomnet.com (PMDF V5.2-33 #42262) with ESMTP id <0GSM00A7Y5HWAI@dgismtp01.wcomnet.com>; Thu, 07 Mar 2002 17:20:21 +0000 (GMT) Date: Thu, 07 Mar 2002 11:21:23 -0600 From: Srinivasa R Chava Subject: Re: pg_restore problem. To: Alex Hudich Cc: pgsql-admin@postgresql.org Message-id: <3C87A193.1FA76194@wcom.com> Organization: WORLDCOM [ http://www.worldcom.com/ ] MIME-version: 1.0 X-Mailer: Mozilla 4.76 [en] (Windows NT 5.0; U) Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7bit X-Accept-Language: en References: X-Archive-Number: 200203/101 X-Sequence-Number: 3635 hi, Before taking backup with pg_dump, give createdb and createuser privileges to all the users of the first database.Then restore it in the second database with pg_restore.I don't know why they made the privileges required for taking backup. --with regrard chava -- Srinivasa R Chava (Chava) - Boss: Sean T Laduderdale vnet4603575 Application Developer Corporate Intra/Internet Systems WORLDCOM - http://www.worldcom.com/ - NASDAQ:WCOM 500 Clinton Center Drive (Corporate Headquarters) Clinton, Mississippi (MS) USA 39056 (601)460-3122 / vnet4603122 / (800)844-1009 / FAX(601)460-8257