From: | Wasim Devale <wasimd60(at)gmail(dot)com> |
---|---|
To: | ronljohnsonjr(at)gmail(dot)com |
Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: Strange "permission denied" errors on pg_restore |
Date: | 2024-06-30 05:13:39 |
Message-ID: | CAB5fag5km49t+MtoSVxWEu2TdA+-PVdSQhpepRFypFf=_VZ80Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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)
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Ron Johnson | 2024-06-30 06:48:07 | Re: Strange "permission denied" errors on pg_restore |
Previous Message | Ron Johnson | 2024-06-29 22:34:52 | Re: Strange "permission denied" errors on pg_restore |