Postgres Error While Processing Toc
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of pg_restore error from toc entry relation does not exist this site About Us Learn more about Stack Overflow the company Business Learn pg_restore error relation does not exist more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question pg_restore: [archiver (db)] could not execute query: error: relation does not exist x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up
Pg_restore: [archiver (db)] Could Not Execute Query: Error: Must Be Owner Of Extension Plpgsql
pg_restore toc error up vote 10 down vote favorite 1 i was using the following syntax for pg_dump and restore pg_dump eval --inserts -b -c --encoding UTF8 -Fc -f eval.sql.tar.gz -x -U postgres createdb -T template0 test -U postgres pg_restore -d test eval.sql.tar.gz -e -U postgres the dump was successfull with no errors, but restore makes a some errors, i am dumping and restoring could not execute query error role does not exist in same machine with same user and privilege all... i have tried out with other formats also, plain, tar, compressed all gets the same error.. my version of pg is 8.4.11 and psql version is 8.4.11 i am not sure what makes these errors.. can anyone help me pg_restore: [archiver (db)] Error while PROCESSING TOC: pg_restore: [archiver (db)] Error from TOC entry 4965; 0 138871 TABLE DATA ir_act_report_xml insigni pg_restore: [archiver (db)] could not execute query: ERROR: invalid input syntax for integer: "purchase.order" LINE 1: ...st for Quotation', 'ir.actions.report.xml', NULL, 'purchase.... ^ Command was: INSERT INTO ir_act_report_xml VALUES (350, 'Request for Quotation', 'ir.actions.report.xml', NULL, 'purchase.order', 'purcha... postgresql pg-dump toc pg-restore share|improve this question asked Mar 23 '12 at 9:19 MAHI 1,21181738 1 Seems you dump is a SQL script that needs to be run using psql, not pg_restore –a_horse_with_no_name Mar 23 '12 at 11:38 add a comment| 1 Answer 1 active oldest votes up vote 10 down vote accepted this did the trick pg_dump database_name -c -Ft -f file_name.tar pg_restore -d database_name -c file_name.tar before this i was trying to restore with out including -c(clean) even
pgsql-announce pgsql-bugs pgsql-docs pgsql-general pgsql-interfaces pgsql-jobs pgsql-novice pgsql-performance pgsql-php pgsql-sql pgsql-students Developer lists Regional lists Associations User groups Project lists Inactive lists IRC Local User Groups Featured Users International Sites Propaganda Resources pg_restore error relation already exists Weekly News Re: pg_restore issue From: Jerry Sievers
Command Was: Comment On Extension Plpgsql Is 'pl/pgsql Procedural Language';
Ramé
Pg_restore Constraint Does Not Exist
or whole thread) Thread: 2014-02-12 17:41:19 from Leonardo M(dot) Ramé
pgsql-announce pgsql-bugs pgsql-docs pgsql-general pgsql-interfaces pgsql-jobs pgsql-novice pgsql-performance pgsql-php pgsql-sql pgsql-students Developer lists Regional lists https://www.postgresql.org/message-id/17A09E9509BB354E95C2FEE5102B0F5F0242084F@audiinsx0036.audi.vwg Associations User groups Project lists Inactive lists IRC Local http://postgresql.nabble.com/pg-restore-issue-td5791634.html User Groups Featured Users International Sites Propaganda Resources Weekly News Problem restoring database From: "Oeschey, Lars (I/EK-142, extern)"
| Threaded Open this post in threaded view ♦ ♦ | Report Content as Inappropriate ♦ ♦ pg_restore issue Hi, I'm trying to restore a database dump using pg_restore with the following parameters: pg_restore -h 127.0.0.1 -U _postgresql \ -c -d postgres --exit-on-error \ my_dump.backup Note I used "\" to wrap the command, but the real one does not have those. pg_restore: [archiver (db)] Error while PROCESSING TOC: pg_restore: [archiver (db)] Error from TOC entry 3156; 2606 432226 FK CONSTRAINT fkidturno postgres pg_restore: [archiver (db)] could not execute query: ERROR: relation "public.turnodocumento" does not exist Command was: ALTER TABLE ONLY public.turnodocumento DROP CONSTRAINT fkidturno; Why is this happening?, should I change the command I'm using to create the backup?. To backup the database I'm using: pg_dump -Fc -h 127.0.0.1 -U postgres mydb > my_dump.backup P.S.: the original db is PostgreSql 8.4, the target is 9.2 Regards, -- Leonardo M. Ramé Medical IT - Griensu S.A. Av. Colón 636 - Piso 8 Of. A X5000EPT -- Córdoba Tel.: +54(351)4246924 +54(351)4247788 +54(351)4247979 int. 19 Cel.: +54 9 (011) 40871877 -- Sent via pgsql-general mailing list ([hidden email]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general Adrian Klaver-3 Reply | Threaded Open this post in threaded view ♦ ♦ | Report Content as Inappropriate ♦ ♦ Re: pg_restore issue On 02/12/2014 09:41 AM, Leonardo M. Ramé wrote: > Hi, I'm trying to restore a database dump using pg_restore with the > following parameters: > > pg_restore -h 127.0.0.1 -U _postgresql \ > -c -d postgres --exit-on-error \ > my_dump.backup > > Note I used "\" to wrap the command, but the real one does not have > those. > > pg_restore: [archiver (db)] Erro