Re: Failure loading materialized view with pg_restore

[Rémi Cura <remi.cura@xxxxxxxxx>]

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@xxxxxxxxx>:

On Wed, Feb 18, 2015 at 5:48 AM, Brian Sutherland <brian@xxxxxxxxxxxxxxxxx> 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.