Thread: Error by restore a database

Error by restore a database

From
"Sbis-Partner"
Date:
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" >.

Please help me to solve this problem.

Re: Error by restore a database

From
John R Pierce
Date:
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

Re: Error by restore a database

From
Michael Paquier
Date:
On Mon, Sep 9, 2013 at 11:38 PM, Sbis-Partner <sbis-partner@mail.ru> wrote:
> Hello!
>
> When you restore a database error occurs
>
> =ABPg_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" d=
oes
> not exist
>
>      Command was: ALTER TABLE public.dbschema OWNER TO "User" =BB.
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.
--=20
Michael