| From: | Rémi Cura <remi(dot)cura(at)gmail(dot)com> |
|---|---|
| To: | BladeOfLight16 <bladeoflight16(at)gmail(dot)com> |
| Cc: | Brian Sutherland <brian(at)vanguardistas(dot)net>, PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Failure loading materialized view with pg_restore |
| Date: | 2015-02-18 12:57:46 |
| Message-ID: | CAJvUf_u_caBWn=w8-pXC6UERRmzT+EULxU4+urBse1L4wLct7w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hey,
pg_hba is to manage who has *access* to database.
Your problem seems to be who has* SELECT permission* to x table.
Cheers,
Rémi-C
2015-02-18 12:03 GMT+01:00 BladeOfLight16 <bladeoflight16(at)gmail(dot)com>:
> On Wed, Feb 18, 2015 at 5:48 AM, Brian Sutherland <brian(at)vanguardistas(dot)net
> > wrote:
>
>> # dump and reload
>> pg_dump --username super --format c -f dump.dump orig
>> createdb copied
>>
>
> It might be helpful to dump in the plain SQL format and look at what it's
> doing.
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Day, David | 2015-02-18 13:07:00 | Re: segmentation fault postgres 9.3.5 core dump perlu related ? |
| Previous Message | Guillaume Drolet | 2015-02-18 12:26:51 | Re: Starting new cluster from base backup |