Request a Demo
Home   >   mailing lists

pg_restore problem to load constraints with tables - Mailing list pgsql-hackers

From Fabrice Chapuis
Subject pg_restore problem to load constraints with tables
Date
Msg-id CAA5-nLAw1vK1XriZgmoK_i5jiyJQjFmFnw_-JJAa7s+m5gYq+A@mail.gmail.com
Whole thread Raw
Responses Re: pg_restore problem to load constraints with tables
List pgsql-hackers
Tree view
Hi,
When a table is reloaded wit pg_restore, it is recreated without indexes or constraints. There are automatically skipped. Is there a reason for this?

g_restore -j 8 -v -d zof /shared/pgdump/aq/backup/dbtest/shtest --no-owner --role=test -t  mytable 2>&1 | tee -a dbest.log 

pg_restore: skipping item 7727 SEQUENCE SET xxx_seq
pg_restore: skipping item 5110 INDEX xxxxx_cons
pg_restore: skipping item 5143 CONSTRAINT xxx 
pg_restore: skipping item 5670 FK CONSTRAINT xxx

Thanks for your feedback

Fabrice


pgsql-hackers by date:

Previous
From: "Andrey M. Borodin"
Date:
Subject: Re: Injection points: some tools to wait and wake
Next
From: "David E. Wheeler"
Date:
Subject: Re: Patch: Add parse_type Function