Error by restore a database

On 9/9/2013 11:38 PM, Sbis-Partner wrote:

When you restore a database error occurs

�Pg_restore: creating TABLE dbschema

pg_restore: [archiver (db)] Error from TOC entry 1428; 1259 83487
TABLE dbschema User

pg_restore: [archiver (db)] could not execute query: ERROR: role
"User" does not exist

Command was: ALTER TABLE public.dbschema OWNER TO "User" �.

Please help me to solve this problem.

users are not stored as part of a single database, they are global to
the database cluster. you need to create any users required by a
given database before you can restore it.

CREATE USER "User" WITH PASSWORD 'somekindapassword';

Note the same is true for tablespaces, if you use those.

--
john r pierce 37N 122W
somewhere on the middle of the left coast

On Mon, Sep 9, 2013 at 11:38 PM, Sbis-Partner <sbis-partner@mail.ru> wrote:

Hello!

When you restore a database error occurs

«Pg_restore: creating TABLE dbschema

pg_restore: [archiver (db)] Error from TOC entry 1428; 1259 83487 TABLE
dbschema User

pg_restore: [archiver (db)] could not execute query: ERROR: role "User" does
not exist

Command was: ALTER TABLE public.dbschema OWNER TO "User" ».

User and group information are missing in your dump, this information
can be retrieved with pg_dumpall. There are two possibilities in your
case:
- Use the dump you created previously and complete it with data from
pg_dumpall --globals-only containing only user and tablespace
information
- Use a global dump with pg_dumpall with the user information as well
as the database
The latter solution is more instinctive IMO, but the former solution
will work fine as well.
--
Michael

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs