Re: Strange "permission denied" errors on pg_restore

To: Ron Johnson <ronljohnsonjr@xxxxxxxxx>
Subject: Re: Strange "permission denied" errors on pg_restore
From: Scott Ribe <scott_ribe@xxxxxxxxxxxxxxxx>
Date: Sat, 29 Jun 2024 16:30:15 -0600
Cc: Pgsql-admin <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
In-reply-to: <CANzqJaC6U4wc9YimW_B-OGDRQeqgfm8Dem5WYy=a1fAd0mFqSw@mail.gmail.com>
References: <CANzqJaBrzXfebHJaDLRWenr4WRgvRssTgEQR_O20N0sSv9MHLw@mail.gmail.com> <792db007dcc03570743afee23aa0da830207f0cf.camel@cybertec.at> <CANzqJaAVrQyJ_4ASm0PkmUQ7+U8PHKMTU4NAGFzM0w4FN5tDrQ@mail.gmail.com> <42d837098e471906e23ed5ef345a1172145c76da.camel@cybertec.at> <CANzqJaBDNN9r=uK3jKtmGCCo2k55fJXK9n6CAhL5WN8pa_0pLQ@mail.gmail.com> <2207734.1719672845@sss.pgh.pa.us> <CANzqJaC6U4wc9YimW_B-OGDRQeqgfm8Dem5WYy=a1fAd0mFqSw@mail.gmail.com>

Could it be that someone accidentally changed ownership after data had been created?

Follow-Ups:
- Re: Strange "permission denied" errors on pg_restore
  - From: Ron Johnson

References:
- Strange "permission denied" errors on pg_restore
  - From: Ron Johnson
- Re: Strange "permission denied" errors on pg_restore
  - From: Laurenz Albe
- Re: Strange "permission denied" errors on pg_restore
  - From: Ron Johnson
- Re: Strange "permission denied" errors on pg_restore
  - From: Laurenz Albe
- Re: Strange "permission denied" errors on pg_restore
  - From: Ron Johnson
- Re: Strange "permission denied" errors on pg_restore
  - From: Tom Lane
- Re: Strange "permission denied" errors on pg_restore
  - From: Ron Johnson