pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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




view thread (2+ messages)  latest in thread

Message-ID: <1088003009.28091.20.camel@sirio>
Permalink:  ../1088003009.28091.20.camel@sirio/
Also on:    postgresql.org/message-id/1088003009.28091.20.camel@sirio

 · 

reply

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