Skip site navigation (1) Skip section navigation (2)

Non existent user error on restore

From: Werner Bohl <wbohl(at)deepdata(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Non existent user error on restore
Date: 2004-06-23 15:03:29
Message-ID: 1088003009.28091.20.camel@sirio (view raw or flat)
Thread:
Lists: pgsql-admin
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 <wbohl(at)deepdata(dot)com>
Infutor de Costa Rica


Responses

pgsql-admin by date

Next:From: Tom LaneDate: 2004-06-23 15:43:05
Subject: Re: Non existent user error on restore
Previous:From: Tom LaneDate: 2004-06-23 14:59:43
Subject: Re: Problems with the connection to a Remote Database.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group