Re: 回复: BUG #16101: tables in the DB is not available after pg_restore

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 回复: BUG #16101: tables in the DB is not available after pg_restore
Дата
Msg-id 5802.1573657223@sss.pgh.pa.us
обсуждение исходный текст
Ответ на 回复: BUG #16101: tables in the DB is not available after pg_restore  ("唯一★" <270246512@qq.com>)
Список pgsql-bugs
"=?gb18030?B?zqjSu6Hv?=" <270246512@qq.com> writes:
> After restore the database via pg_restore,  the search_path look well and is the same as before restore.

This looks like maybe your user "cm" lacks permissions on the public
schema?  If "select current_schemas(true)" doesn't show the public
schema as part of the active search path, that's probably your issue.
"\dn+" is another way to check.

            regards, tom lane



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

Предыдущее
От: Tomas Vondra
Дата:
Сообщение: Re: BUG #16112: large, unexpected memory consumption
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Random crashes - segmentation fault