pg_restore problem to load constraints with tables

From: Fabrice Chapuis <fabrice636861(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: pg_restore problem to load constraints with tables
Date: 2024-02-20 14:44:47
Message-ID: CAA5-nLAw1vK1XriZgmoK_i5jiyJQjFmFnw_-JJAa7s+m5gYq+A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David E. Wheeler 2024-02-20 14:44:48 Re: Patch: Add parse_type Function
Previous Message Andrey M. Borodin 2024-02-20 14:32:38 Re: Injection points: some tools to wait and wake