restore error
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
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, 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