Re: Help with "gpg -d ... | pg_restore ..." with unimportant pg_restore errors

2024-09-03 Thread raf
On Tue, Sep 03, 2024 at 10:28:44PM -0400, Tom Lane wrote: > raf writes: > > On Tue, Sep 03, 2024 at 06:43:22PM -0700, "David G. Johnston" > > wrote: > >> You specified “-1” so I don’t get why you believe pg_restore should be > >> continuing to execute in the face of the SQL error. > > > The r

Re: Help with "gpg -d ... | pg_restore ..." with unimportant pg_restore errors

2024-09-03 Thread Tom Lane
raf writes: > On Tue, Sep 03, 2024 at 06:43:22PM -0700, "David G. Johnston" > wrote: >> You specified “-1” so I don’t get why you believe pg_restore should be >> continuing to execute in the face of the SQL error. > The reason I believe pg_restore should be continuing to execute in the face of

Re: Help with "gpg -d ... | pg_restore ..." with unimportant pg_restore errors

2024-09-03 Thread raf
On Tue, Sep 03, 2024 at 06:43:22PM -0700, "David G. Johnston" wrote: > On Tuesday, September 3, 2024, raf wrote: > > > Hi, > > > > I need help! > > > > I'm upgrading an ancient (but still awesome) postgresql-9.6.24 (via > > EnterpriseDB) > > to (a no doubt even more awesome) postgresql-15.8 (v

Re: Help with "gpg -d ... | pg_restore ..." with unimportant pg_restore errors

2024-09-03 Thread David G. Johnston
On Tuesday, September 3, 2024, raf wrote: > Hi, > > I need help! > > I'm upgrading an ancient (but still awesome) postgresql-9.6.24 (via > EnterpriseDB) > to (a no doubt even more awesome) postgresql-15.8 (via debian (stable) > packages) > but am unable to load database backups that were encrypte