pg_dump and pg_restore and foreign keys - Mailing list pgsql-general

From Tore Halvorsen
Subject pg_dump and pg_restore and foreign keys
Date
Msg-id CADGw-Sc7dKvR1j6efmXxUJc6ePWpfvKGACcfw30Pytv-7Da6JA@mail.gmail.com
Whole thread Raw
Responses Re: pg_dump and pg_restore and foreign keys
List 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

pgsql-general by date:

Previous
From: Marcos Pegoraro
Date:
Subject: Re: Determining if a table really changed in a trigger
Next
From: Magnus Hagander
Date:
Subject: Re: Python3 for PostgreSQL 14