X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 86C0A9FA621 for ; Mon, 24 Jul 2006 21:46:40 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 08235-05 for ; Tue, 25 Jul 2006 00:46:32 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 599FB9FA441 for ; Mon, 24 Jul 2006 21:46:32 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from talk.nabble.com (www.nabble.com [72.21.53.35]) by svr4.postgresql.org (Postfix) with ESMTP id 6FFD65AFB27 for ; Tue, 25 Jul 2006 00:46:31 +0000 (GMT) Received: from [72.21.53.38] (helo=jubjub.nabble.com) by talk.nabble.com with esmtp (Exim 4.50) id 1G5B4A-0007DT-8o for pgsql-admin@postgresql.org; Mon, 24 Jul 2006 17:46:30 -0700 Message-ID: <5478199.post@talk.nabble.com> Date: Mon, 24 Jul 2006 17:46:30 -0700 (PDT) From: Paul S To: pgsql-admin@postgresql.org Subject: Re: problem backup/restore PSQL DB In-Reply-To: <75c69f690607241726r1a640b2excab3439485cdff63@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-Sender: plabrh1@gmail.com X-Nabble-From: Paul S References: <75c69f690607241726r1a640b2excab3439485cdff63@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.069 tagged_above=0 required=5 tests=SPF_NEUTRAL X-Spam-Level: * X-Archive-Number: 200607/195 X-Sequence-Number: 22441 It looks like it's a user configuration issue. I have hit user setup issues while restoring DB's before and generally I find it useful to create the Users and/or Groups manually on the new server first before restoring the DB's whenever I hit problems like that. Try syncing the users manually, (assuming that there are only a few and that it could be done manually with some level of ease) and then try restoring again. -Paul -- View this message in context: http://www.nabble.com/problem-backup-restore-PSQL-DB-tf1995768.html#a5478199 Sent from the PostgreSQL - admin forum at Nabble.com.