Re: Strange "permission denied" errors on pg_restore

We *can*, but the software vendor wants everything owned by the service
account.

On Sun, Jun 30, 2024 at 1:13 AM Wasim Devale <wasimd60(at)gmail(dot)com> wrote:

> Can we change relowner to 10 ? After data is loaded in the database?
>
> On Sun, 30 Jun, 2024, 4:05 am Ron Johnson, <ronljohnsonjr(at)gmail(dot)com>
> wrote:
>
>> On Sat, Jun 29, 2024 at 6:30 PM Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
>> wrote:
>>
>>> Could it be that someone accidentally changed ownership after data had
>>> been created?
>>>
>>
>> All tables (except one named "foo") are owned by the service account
>> fis_tap.
>>
>> postgres=# select oid
>> postgres=# from pg_roles
>> postgres-# where rolname='fis_tap';
>> oid
>> -------
>> 16386
>> (1 row)
>>
>> tap=# select relowner, count(*)
>> from pg_class
>> where relkind in ('r', 't', 'p')
>> and relnamespace::regnamespace::text = 'tapschema'
>> group by relowner;
>> relowner | count
>> ----------+-------
>> 10 | 1
>> 16386 | 30980
>> (2 rows)
>>
>>