Обсуждение: permission errors for set authority and schema public

Поиск
Список
Период
Сортировка

permission errors for set authority and schema public

От
CSN
Дата:
I upgraded to 7.4 a few days ago and am getting these
errors when importing dumps: "permission denied to set
session authority" and "permission denied for schema
public". Not all of the dump is imported successfully.
Are these errors due to new features in 7.4? Do I need
to add more permissions for users?

__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/

Re: permission errors for set authority and schema public

От
Peter Eisentraut
Дата:
CSN writes:

> I upgraded to 7.4 a few days ago and am getting these
> errors when importing dumps: "permission denied to set
> session authority" and "permission denied for schema
> public". Not all of the dump is imported successfully.

Looks like you need to restore as superuser.

--
Peter Eisentraut   peter_e@gmx.net