Re: pg_dump and pg_restore and foreign keys

2021-10-28 Thread Tore Halvorsen
ninfo->condef , dopt->foreign_keys_not_valid && !strstr(coninfo->condef, "NOT VALID") ? " NOT VALID":""); On Wed, Oct 27, 2021 at 4:08 PM Tore Halvorsen wrote: > Then I'll try that, thank you :) > > On Wed, Oct 27, 2021 at 4:04 PM Tom L

Re: pg_dump and pg_restore and foreign keys

2021-10-27 Thread Tore Halvorsen
Then I'll try that, thank you :) On Wed, Oct 27, 2021 at 4:04 PM Tom Lane wrote: > Tore Halvorsen writes: > > That would be appending it for "pg_catalog.pg_get_constraintdef(oid) AS > > condef" in getConstraints in pg_dump.c? > > No, you want to mess with the

Re: pg_dump and pg_restore and foreign keys

2021-10-27 Thread Tore Halvorsen
That would be appending it for "pg_catalog.pg_get_constraintdef(oid) AS condef" in getConstraints in pg_dump.c? On Wed, Oct 27, 2021 at 3:27 PM Tom Lane wrote: > Tore Halvorsen writes: > > I'm trying to restore a database where adding foreign key constraints > takes >

pg_dump and pg_restore and foreign keys

2021-10-27 Thread Tore Halvorsen
ren og sol på eng gjer mannen fegen og fjåg. [Jøtul] Tore Halvorsen || +052 0553034554

Replication slots for cascading replication.

2018-02-05 Thread Tore Halvorsen
Hi, I encountered an issue this weeked and was wondering if there is a simple solution to avoid this specific problem. A simplified database setup here i three servers, which uses streaming replication with replication slot on pg10.1 M: a "master" server C: a hot standby that cascades to ... S: