Thread: Error by restore a database
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.
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 > > =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