Re: Strange "permission denied" errors on pg_restore

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Strange "permission denied" errors on pg_restore
Дата
Msg-id CANzqJaAedjqJQp-btsOO=qeRrj-y6K89f6OSHc=Xe-g37fA6Xg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Strange "permission denied" errors on pg_restore  (Scott Ribe <scott_ribe@elevated-dev.com>)
Ответы Re: Strange "permission denied" errors on pg_restore  (Wasim Devale <wasimd60@gmail.com>)
Список pgsql-admin
Дерево обсуждения
On Sat, Jun 29, 2024 at 6:30 PM Scott Ribe <scott_ribe@elevated-dev.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)

В списке pgsql-admin по дате отправления:

Предыдущее
От: Scott Ribe
Дата:
Сообщение: Re: Strange "permission denied" errors on pg_restore
Следующее
От: Wasim Devale
Дата:
Сообщение: Re: Strange "permission denied" errors on pg_restore