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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: 唯一★ <270246512(at)qq(dot)com>
Cc: Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>, pgsql-bugs <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: 回复： BUG #16101: tables in the DB is not available after pg_restore
Date: 2019-11-13 15:00:23
Message-ID: 5802.1573657223@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"=?gb18030?B?zqjSu6Hv?=" <270246512(at)qq(dot)com> writes:
> After restore the database via pg_restore,&nbsp; 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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2019-11-13 15:07:03 Re: Random crashes - segmentation fault
Previous Message Tomas Vondra 2019-11-13 14:50:04 Re: BUG #16112: large, unexpected memory consumption