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 4F531D1B53B for ; Wed, 23 Jun 2004 12:03:43 -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 69978-08 for ; Wed, 23 Jun 2004 15:03:41 +0000 (GMT) Received: from twister.bcentralhost.com (twister.bcentralhost.com [205.158.155.24]) by svr1.postgresql.org (Postfix) with ESMTP id 38F83D1B2BD for ; Wed, 23 Jun 2004 12:03:40 -0300 (ADT) Received: from [192.168.2.2] ([200.12.238.167]) by twister.bcentralhost.com id LAA24119; Wed, 23 Jun 2004 11:03:34 -0400 (EDT) [ConcentricHost SMTP Relay 1.14] Subject: Non existent user error on restore From: Werner Bohl Reply-To: wbohl@deepdata.com To: pgsql-admin@postgresql.org Content-Type: text/plain Organization: Infutor de Costa Rica Message-Id: <1088003009.28091.20.camel@sirio> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Wed, 23 Jun 2004 09:03:29 -0600 Content-Transfer-Encoding: 7bit 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/307 X-Sequence-Number: 13967 I'm using Postgresql 7.4.2 on RedHat 9. We backup a database weekly with the following command: pg_dump --clean --create --verbose --format=c \ --compress 9 -U admin $DBSID \ | dbdumpsplit $DBSID.dump where $DBSID is the database name. The database is very large, so we split the dump in 1GB chunks. Created a new database to hold a copy of the backup. Then issued cat $DBSID.dump* | pg_restore -d NEW_DB This errs with following message: pg_restore: [archiver (db)] could not execute query: ERROR: user "100" does not exist Issuing a \du does not list a user with name or id 100 on the backed-up database. Created a user with: createuser -i 100 dropme Run the restore again, but gave same error! Tried to drop the user: dropuser dropme and it returned an error saying that user dropme owned a database and could not be dropped. Please help me cause I'm really baffled with this odd behavior. -- Werner Bohl Infutor de Costa Rica