Thanks, I'll check it out. Regards, Prakash.R
On Tue, Jul 2, 2019 at 1:05 PM Laurenz Albe <laurenz.a...@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
