Thread: pg_restore problem to load constraints with tables
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
Fabrice Chapuis <fabrice636861@gmail.com> writes: > 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? [ shrug ] That's how the -t switch is defined. If you want something else, you can use the -l and -L switches to pick out a custom collection of objects to restore. regards, tom lane