| From: | Nicola Contu <nicola(dot)contu(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Cc: | Alessandro Aste <Alessandro(dot)aste(at)gtt(dot)net> |
| Subject: | Restore from dumps |
| Date: | 2018-07-25 07:43:56 |
| Message-ID: | CAMTZZh0-v1JBKyyNxF=D2nHecetDxX05cT=PkqqmBUtpK-TKKg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello,
we recently moved from postgres 9.6.6 to 10.4
We perform a pg_dump in production to restore daily in a preprod env.
This process used to work perfectly, but now we have a tiny problem.
We first restore data, we perform a vacuum and then we restore matviews.
Restoring matviews now we have :
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 23090; 0 1912379424
MATERIALIZED VIEW DATA matview_vrs_request_sla postgres
pg_restore: [archiver (db)] could not execute query: ERROR: relation
"all_days" does not exist
LINE 3: from all_days
^
QUERY:
select count(*)::numeric
from all_days
where (("date" between $2::date and $1::date) or ("date" between $1::date
and $2::date))
and dow not in (0,6)
CONTEXT: SQL function "bdays" during inlining
Command was: REFRESH MATERIALIZED VIEW public.matview_vrs_request_sla;
The relation is there, in fact if I go there when I get in to the office,
the same command works.
I'm not sure why it does not work here, this seems really strange to me.
Can anyone help?
Thank you,
Nicola
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alban Hertroys | 2018-07-25 09:28:45 | Re: Restore from dumps |
| Previous Message | Jeff Janes | 2018-07-25 02:13:31 | Re: Dealing with latency to replication slave; what to do? |