Postgres Pro
Downloads
Home   >   mailing lists

Re: Failure loading materialized view with pg_restore - Mailing list pgsql-general

From BladeOfLight16
Subject Re: Failure loading materialized view with pg_restore
Date
Msg-id CA+=1U=VJRwyDBHe6gTzNpP-7wMR5rJc5Y7QOGpuaxmAuD=6N1A@mail.gmail.com
Whole thread Raw
In response to Failure loading materialized view with pg_restore  (Brian Sutherland <brian@vanguardistas.net>)
Responses Re: Failure loading materialized view with pg_restore  (Rémi Cura <remi.cura@gmail.com>)
List pgsql-general
Tree view
On Wed, Feb 18, 2015 at 5:48 AM, Brian Sutherland <brian@vanguardistas.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.

pgsql-general by date:

Previous
From: Brian Sutherland
Date:
Subject: Failure loading materialized view with pg_restore
Next
From: Bill Moran
Date:
Subject: Re: postgresql93-9.3.5: deadlock when updating parent table expected?