RE: pg_restore restores out of order

2020-03-12 Thread Kevin Brannen
>Adrian Klaver wrote: >> Kevin Brannen wrote: >> It goes on to say a trigger is the right way to do this. So yeah, a >> "tightening of the code" seems to be hitting me because of bad code from the >> past. >> >> Problem identified and I'll solve it tomorrow. > >Glad it was solved. > >However, look

Re: pg_restore restores out of order

2020-03-11 Thread Adrian Klaver
On 3/11/20 4:11 PM, Kevin Brannen wrote: Adrian Klaver wrote: On 3/11/20 2:46 PM, Kevin Brannen wrote: I'm working thru our system to upgrade from 9.6.5 to 12.2. One of the last things I'm verifying is backup/restore and it's failing for no reason I can figure out. So I'm looking for pointers

RE: pg_restore restores out of order

2020-03-11 Thread Kevin Brannen
>Adrian Klaver wrote: >On 3/11/20 2:46 PM, Kevin Brannen wrote: >> I'm working thru our system to upgrade from 9.6.5 to 12.2. One of the last >> things I'm verifying is backup/restore and it's failing for no reason I can >> figure out. So I'm looking for pointers on this. >> >> If it matters, the

Re: pg_restore restores out of order

2020-03-11 Thread Adrian Klaver
On 3/11/20 2:46 PM, Kevin Brannen wrote: I'm working thru our system to upgrade from 9.6.5 to 12.2. One of the last things I'm verifying is backup/restore and it's failing for no reason I can figure out. So I'm looking for pointers on this. If it matters, the code is from the version 12.2 from