Re: BUG #11128: Error in pg_restore with materialized view

mpmilanez wrote
> The following bug has been logged on the website:
>
> Bug reference: 11128
> Logged by: Marcos Paulo Milanêz Santana
> Email address:

> mpmilanez@

> PostgreSQL version: 9.3.4
> Operating system: CentOS 6.5
> Description:
>
> I'm trying to restore a database after creating some materialized views.
> This is the command used for dump: pg_dump --blobs -Fc -f
> bkp_database_siop.dmp.fc -x siop;
> The command used for restore: pg_restore -Fc -C -O -x -v -j 4
> --disable-triggers -d postgres bkp_database_siop.dmp.fc;
> Here is the error I get:

There were quite a few pg_restore fixes, including some related to
materialized views, in 9.3.5 so I'd suggest upgrading and trying again. If
it still fails (or you cannot upgrade for some reason) you would probably
need to supply a minimal example that reproduces the behavior.

David J.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/BUG-11128-Error-in-pg-restore-with-materialized-view-tp5813835p5813843.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.