From: Werner Bohl <wbohl@deepdata.com>
To: pgsql-admin@postgresql.org
Subject: Non existent user error on restore
Date: Wed, 23 Jun 2004 09:03:29 -0600
Message-ID: <1088003009.28091.20.camel@sirio> (raw)
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@deepdata.com>
Infutor de Costa Rica
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: wbohl@deepdata.com
Subject: Re: Non existent user error on restore
In-Reply-To: <1088003009.28091.20.camel@sirio>
References: <1088003009.28091.20.camel@sirio>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox