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

From Yash Raj
Subject Re: BUG #16601: Restore Issue
Date
Msg-id CAL_dhWt1Y=MDA5wg0jKO0iV0-sw7shQVJSvgm9KX8un2iEn+DA@mail.gmail.com
Whole thread Raw
In response to Re: BUG #16601: Restore Issue  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-bugs
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 earliest

This 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

pgsql-bugs by date:

Previous
From: Alexander Korotkov
Date:
Subject: Re: BUG #16592: websearch_to_tsquery() returns queries that don't result in expected matches
Next
From: "David G. Johnston"
Date:
Subject: Re: BUG #16601: Restore Issue