From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | susan(dot)hurst(at)brookhurstdata(dot)com |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Missing Trigger after pgdump install |
Date: | 2019-08-18 16:25:10 |
Message-ID: | 14188.1566145510@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Susan Hurst <susan(dot)hurst(at)brookhurstdata(dot)com> writes:
> Error from Postgres server log (postgresql-2019-08-16_140110.log):
> 2019-08-16 14:04:24 CDT ERROR: relation "devops.subscribers" does not
> exist
> 2019-08-16 14:04:24 CDT STATEMENT: create trigger subscribers_iur_trg
> instead of update
> on devops.subscribers
> for each row
> execute procedure devops.subscribers_update();
This log file is definitely where you should be looking for more
information. Is that the *only* message that appears while trying
to restore the dump file?
Is the pg_dump version that's being used to create the dump file 9.5.0,
or something later? (Use pg_dump --version if you're unsure --- but
I'm suspicious that it's 9.5.0, if it's from the source server
installation.)
Trawling the commit log, I see a number of post-9.5.0 bug fixes related to
pg_dump's handling of views that have index dependencies. I wonder whether
any of those are related to this. The symptoms don't seem to quite match,
but ...
> CREATE VIEW subscribers appears on line 11,968 in the dump file
Is it possible that you've got more than one view named "subscribers",
in different schemas? If so this might not be the relevant entry.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Kyotaro Horiguchi | 2019-08-19 04:21:02 | Re: question about zeroes in the wal file names |
Previous Message | Luca Ferrari | 2019-08-18 14:17:03 | question about zeroes in the wal file names |