Re: permission denied for large object 200936761

Поиск
Список
Период
Сортировка
От Andrus
Тема Re: permission denied for large object 200936761
Дата
Msg-id b0c71270-e5dd-76d8-8488-3e5ba3ace4ef@hot.ee
обсуждение исходный текст
Ответ на Re: permission denied for large object 200936761  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: permission denied for large object 200936761  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Hi!

 >Large objects exist independent of those. The important part of the above is lomowner. Use that oid to find the role that owns the objects here:

/select rolname from pg_roles where oid = 30152 ; //

Not sure what the above is supposed to be doing?

I showed the user definition

It havent created any large objects.

What hasn't created large objects?
I


How to use this information to fix the issue ?

Do the pg_dump as user clusteradmin.

This works. However I need to allow non-supoeruser to create backup also. How to do this ?

Andrus.

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: permission denied for large object 200936761
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Segmentation fault on startup