| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Prakash Ramakrishnan <prakash(dot)ramakrishnan(dot)ap(at)nielsen(dot)com>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: restore error |
| Date: | 2019-07-02 07:35:32 |
| Message-ID: | 3cdbeaef3337779e7276cf7074ddac43fe169e37.camel@cybertec.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Prakash Ramakrishnan wrote:
> While restoring the database using psql getting below error any idea about this?
>
> psql:AICH01PR.sql:641367264: ERROR: connection for foreign table "mf_adm_spotservicefiles" cannot be established
> DETAIL: ORA-12170: TNS:Connect timeout occurred
Just guessing:
Perhaps there is a materialized view that is based on a foreign table,
and when PostgreSQL tries to populate the materialized view during
the restore, it fails to connect to the remote database.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Prakash Ramakrishnan | 2019-07-02 07:36:50 | Re: restore error |
| Previous Message | JOULAUD François | 2019-07-02 07:25:27 | "invalid contrecord" error on replica |