Werner Bohl <[EMAIL PROTECTED]> 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
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 1
