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 CEC74D1B73E for ; Wed, 23 Jun 2004 12:43:11 -0300 (ADT) 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 03428-04 for ; Wed, 23 Jun 2004 15:43:10 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id D8AA7D1B199 for ; Wed, 23 Jun 2004 12:43:09 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i5NFh6qb002867; Wed, 23 Jun 2004 11:43:06 -0400 (EDT) To: wbohl@deepdata.com Cc: pgsql-admin@postgresql.org Subject: Re: Non existent user error on restore In-reply-to: <1088003009.28091.20.camel@sirio> References: <1088003009.28091.20.camel@sirio> Comments: In-reply-to Werner Bohl message dated "Wed, 23 Jun 2004 09:03:29 -0600" Date: Wed, 23 Jun 2004 11:43:05 -0400 Message-ID: <2866.1088005385@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200406/308 X-Sequence-Number: 13968 Werner Bohl writes: > pg_restore: [archiver (db)] could not execute query: ERROR: user "100" > does not exist I'd suggest doing a plain text schema-only dump (pg_dump -s) and looking through it for references to userid 100. You have presumably got some objects in the database that are owned by a now-gone user. Fixing their ownership would be the best long-term solution. > Created a user with: > createuser -i 100 dropme > Run the restore again, but gave same error! I think you'd actually need "createuser 100", ie, the name not the sysid is what's being complained of above. It might be prudent to give it sysid 100 as well, though. regards, tom lane