Postgres Pro
Downloads
Home   >   mailing lists

Thread: restore error

restore error

From
Prakash Ramakrishnan
Date:

Hi Team,

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


--
Thanks,
Prakash.R

Re: restore error

From
Laurenz Albe
Date:
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

Re: restore error

From
Prakash Ramakrishnan
Date:
Thanks, I'll check it out. 

Regards,
Prakash.R

On Tue, Jul 2, 2019 at 1:05 PM Laurenz Albe <laurenz.albe@cybertec.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