pg_restore issue - Mailing list pgsql-general

From Leonardo M. Ramé
Subject pg_restore issue
Date
Msg-id 20140212174119.GA6171@leonardo-laptop
Whole thread Raw
Responses Re: pg_restore issue
Re: pg_restore issue
List pgsql-general
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



pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: function with different return type depending on parameter?
Next
From: Adrian Klaver
Date:
Subject: Re: pg_restore issue