Re: Strange "permission denied" errors on pg_restore

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Can we change relowner to 10 ? After data is loaded in the database?


On Sun, 30 Jun, 2024, 4:05 am Ron Johnson, <ronljohnsonjr@xxxxxxxxx> wrote:
On Sat, Jun 29, 2024 at 6:30 PM Scott Ribe <scott_ribe@xxxxxxxxxxxxxxxx> 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)



[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux