Thread: BUG #16601: Restore Issue
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":
On Sat, Aug 29, 2020 at 1:15 AM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Fri, Aug 28, 2020 at 12:27 PM PG Bug reporting form <noreply@postgresql.org> wrote:The following bug has been logged on the website:
Bug reference: 16601
Logged by: Yash Raj
Email address: yashraj7960@gmail.com
PostgreSQL version: 13beta3
Operating system: windows 10
Description:
I create a database in pgadmin 4 and I'm trying to import the sql file. It
throws an error like schema public is already exists and i'm unable to run
the file and create tables with data. Please help me out in this at earliestThis isn't a bug - future questions of this nature should be sent to either the -novice or -general lists.Manually drop the public schema in your created database before restoring your sql file into it.David J.
Regards
Yash
Thank you for the clarification. How can I install the module can you please suggest me the process of installing it?
On Sun, 30 Aug 2020 at 12:28 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:
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.
Regards
Yash
Read the installation instructions for the aforementioned software.
On Sunday, August 30, 2020, Yash Raj <yashraj7960@gmail.com> wrote:
On Sunday, August 30, 2020, Yash Raj <yashraj7960@gmail.com> wrote:
Thank you for the clarification. How can I install the module can you please suggest me the process of installing it?--On Sun, 30 Aug 2020 at 12:28 PM, David G. Johnston <david.g.johnston@gmail.com> wrote: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.RegardsYash
Hi, I got stuck at installing pgrouting, postgis, postgis topology extension. Could you help me on this please?
On Sun, 30 Aug 2020 at 7:40 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:
Read the installation instructions for the aforementioned software.
On Sunday, August 30, 2020, Yash Raj <yashraj7960@gmail.com> wrote:Thank you for the clarification. How can I install the module can you please suggest me the process of installing it?--On Sun, 30 Aug 2020 at 12:28 PM, David G. Johnston <david.g.johnston@gmail.com> wrote: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.RegardsYash
Regards
Yash
Someone may but it won't be me.
David J.
On Mon, Aug 31, 2020 at 11:05 AM Yash Raj <yashraj7960@gmail.com> wrote:
Hi, I got stuck at installing pgrouting, postgis, postgis topology extension. Could you help me on this please?--On Sun, 30 Aug 2020 at 7:40 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:Read the installation instructions for the aforementioned software.
On Sunday, August 30, 2020, Yash Raj <yashraj7960@gmail.com> wrote:Thank you for the clarification. How can I install the module can you please suggest me the process of installing it?--On Sun, 30 Aug 2020 at 12:28 PM, David G. Johnston <david.g.johnston@gmail.com> wrote: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.RegardsYashRegardsYash
Ok, thanks.
On Tue, 1 Sep 2020 at 1:58 AM, David G. Johnston <david.g.johnston@gmail.com> wrote:
Someone may but it won't be me.David J.On Mon, Aug 31, 2020 at 11:05 AM Yash Raj <yashraj7960@gmail.com> wrote:Hi, I got stuck at installing pgrouting, postgis, postgis topology extension. Could you help me on this please?--On Sun, 30 Aug 2020 at 7:40 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:Read the installation instructions for the aforementioned software.
On Sunday, August 30, 2020, Yash Raj <yashraj7960@gmail.com> wrote:Thank you for the clarification. How can I install the module can you please suggest me the process of installing it?--On Sun, 30 Aug 2020 at 12:28 PM, David G. Johnston <david.g.johnston@gmail.com> wrote: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.RegardsYashRegardsYash
Regards
Yash