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
