BUG #11128: Error in pg_restore with materialized view

From: mpmilanez(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #11128: Error in pg_restore with materialized view
Date: 2014-08-05 21:56:32
Message-ID: 20140805215632.2708.93022@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 11128
Logged by: Marcos Paulo Milanêz Santana
Email address: mpmilanez(at)gmail(dot)com
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:

pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 12351; 0 3565870
MATERIALIZED VIEW DATA vw_ws_execucaoorcamentaria_mensal_sispes postgres
pg_restore: [archiver (db)] could not execute query: Command was:
REFRESH MATERIALIZED VIEW vw_ws_execucaoorcamentaria_mensal_sispes;
pg_restore: finished item 12351 MATERIALIZED VIEW DATA
vw_ws_execucaoorcamentaria_mensal_sispes
pg_restore: launching item 9983 CONSTRAINT pk_analiseemenda
pg_restore: [archiver (db)] could not execute query: no connection to the
server
Command was: SET statement_timeout = 0;
pg_restore: [archiver (db)] could not execute query: no connection to the
server
Command was: SET lock_timeout = 0;
pg_restore: [archiver (db)] could not execute query: no connection to the
server
Command was: SET client_encoding = 'UTF8';
pg_restore: [archiver (db)] could not execute query: no connection to the
server
Command was: SET standard_conforming_strings = on;
pg_restore: [archiver (db)] could not execute query: no connection to the
server
Command was: SET check_function_bodies = false;
pg_restore: [archiver (db)] could not execute query: no connection to the
server
Command was: SET client_min_messages = warning;
pg_restore: [archiver (db)] could not execute query: no connection to the
server
Command was:
pg_restore: creating CONSTRAINT pk_analiseemenda
pg_restore: [archiver] Error from TOC entry 9983; 2606 18281 CONSTRAINT
pk_analiseemenda postgres
pg_restore: [archiver] could not set search_path to "emenda": no connection
to the server
pg_restore: [archiver] could not set default_tablespace to "": no connection
to the server
pg_restore: [archiver (db)] could not execute query: no connection to the
server
Command was: ALTER TABLE ONLY analiseemenda
ADD CONSTRAINT pk_analiseemenda PRIMARY KEY (analiseemendaid);
pg_restore: finished item 9983 CONSTRAINT pk_analiseemenda
pg_restore: launching item 9984 INDEX uk_analiseemenda_01
pg_restore: [archiver (db)] could not execute query: no connection to the
server
Command was: SET statement_timeout = 0;
...

I've tried restoring the dump with just one job instead of 4. It finished
with success, but the total time increased by approximately 2h.

What do I need to do to fix this?

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message rpvoland 2014-08-05 21:57:32 Re: BUG #11039: installation fails when trying to install C++ redistributable
Previous Message Marcos Paulo Milanêz Santana 2014-08-05 19:04:51 Bug