| From: | Prakash Ramakrishnan <prakash(dot)ramakrishnan(dot)ap(at)nielsen(dot)com> |
|---|---|
| To: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
| Cc: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: restore error |
| Date: | 2019-07-02 07:36:50 |
| Message-ID: | CAA2eZXyUiB_t6CV1MxMr=Agytgodh-MkQ-bi-nGVXbYLJREayQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Thanks, I'll check it out.
Regards,
Prakash.R
On Tue, Jul 2, 2019 at 1:05 PM Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
wrote:
> 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
>
>
--
Thanks,
Prakash.R
PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On call
: +91-8939599426
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Prakash Ramakrishnan | 2019-07-02 07:39:19 | |
| Previous Message | Laurenz Albe | 2019-07-02 07:35:32 | Re: restore error |