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
