Re: BUG #16601: Restore Issue - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: BUG #16601: Restore Issue
Date
Msg-id CAKFQuwZjqarbBS1y4AFArXAvoGgMkLyuJh2LczEHaoQFMh+RHg@mail.gmail.com
Whole thread Raw
In response to BUG #16601: Restore Issue  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #16601: Restore Issue  (Yash Raj <yashraj7960@gmail.com>)
List pgsql-bugs
On Sat, Aug 29, 2020 at 10:27 PM Yash Raj <yashraj7960@gmail.com> wrote:
Hi David,

Could you please help me out to fix this issue?

pg_restore: error: could not execute query: ERROR: could not open extension control file "C:/xampp/pgsql/13/share/extension/postgis.control":


Best I can do is point out that the error implies that you haven't installed postgis as part of the PostgreSQL server.  You will need to install the external module into the server before restoring a database that uses it - namely via executing CREATE EXTENSION.

David J.

pgsql-bugs by date:

Previous
From: Yash Raj
Date:
Subject: Re: BUG #16601: Restore Issue
Next
From: Yash Raj
Date:
Subject: Re: BUG #16601: Restore Issue