Re: 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