pg_dump and pg_restore and foreign keys

From: Tore Halvorsen <tore(dot)halvorsen(at)gmail(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: pg_dump and pg_restore and foreign keys
Date: 2021-10-27 11:27:26
Message-ID: CADGw-Sc7dKvR1j6efmXxUJc6ePWpfvKGACcfw30Pytv-7Da6JA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I hope this is the correct place for this question.

I'm trying to restore a database where adding foreign key constraints takes
most of the time. Does there exist a simple way to make either pg_dump or
pg_restore handle them as "not valid", and defer the validation.

--
Eld på åren og sol på eng gjer mannen fegen og fjåg. [Jøtul]
<demo> Tore Halvorsen || +052 0553034554

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2021-10-27 13:10:34 Re: Python3 for PostgreSQL 14
Previous Message Marcos Pegoraro 2021-10-27 10:56:20 Re: Determining if a table really changed in a trigger