pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
BUG #16601: Restore Issue
9+ messages / 3 participants
[nested] [flat]

* BUG #16601: Restore Issue
@ 2020-08-28 19:04 PG Bug reporting form <noreply@postgresql.org>
  2020-08-28 19:45 ` Re: BUG #16601: Restore Issue David G. Johnston <david.g.johnston@gmail.com>
  0 siblings, 1 reply; 9+ messages in thread

From: PG Bug reporting form @ 2020-08-28 19:04 UTC (permalink / raw)
  To: pgsql-bugs@lists.postgresql.org; +Cc: yashraj7960@gmail.com

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



^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: BUG #16601: Restore Issue
  2020-08-28 19:04 BUG #16601: Restore Issue PG Bug reporting form <noreply@postgresql.org>
@ 2020-08-28 19:45 ` David G. Johnston <david.g.johnston@gmail.com>
  2020-08-30 06:58   ` Re: BUG #16601: Restore Issue David G. Johnston <david.g.johnston@gmail.com>
  0 siblings, 1 reply; 9+ messages in thread

From: David G. Johnston @ 2020-08-28 19:45 UTC (permalink / raw)
  To: yashraj7960@gmail.com, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>

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.

^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: BUG #16601: Restore Issue
  2020-08-28 19:04 BUG #16601: Restore Issue PG Bug reporting form <noreply@postgresql.org>
  2020-08-28 19:45 ` Re: BUG #16601: Restore Issue David G. Johnston <david.g.johnston@gmail.com>
@ 2020-08-30 06:58   ` David G. Johnston <david.g.johnston@gmail.com>
  2020-08-30 08:46     ` Re: BUG #16601: Restore Issue Yash Raj <yashraj7960@gmail.com>
  0 siblings, 1 reply; 9+ messages in thread

From: David G. Johnston @ 2020-08-30 06:58 UTC (permalink / raw)
  To: Yash Raj <yashraj7960@gmail.com>; +Cc: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>

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.

^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: BUG #16601: Restore Issue
  2020-08-28 19:04 BUG #16601: Restore Issue PG Bug reporting form <noreply@postgresql.org>
  2020-08-28 19:45 ` Re: BUG #16601: Restore Issue David G. Johnston <david.g.johnston@gmail.com>
  2020-08-30 06:58   ` Re: BUG #16601: Restore Issue David G. Johnston <david.g.johnston@gmail.com>
@ 2020-08-30 08:46     ` Yash Raj <yashraj7960@gmail.com>
  2020-08-30 14:10       ` Re: BUG #16601: Restore Issue David G. Johnston <david.g.johnston@gmail.com>
  0 siblings, 1 reply; 9+ messages in thread

From: Yash Raj @ 2020-08-30 08:46 UTC (permalink / raw)
  To: David G. Johnston <david.g.johnston@gmail.com>; +Cc: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>

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*

^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: BUG #16601: Restore Issue
  2020-08-28 19:04 BUG #16601: Restore Issue PG Bug reporting form <noreply@postgresql.org>
  2020-08-28 19:45 ` Re: BUG #16601: Restore Issue David G. Johnston <david.g.johnston@gmail.com>
  2020-08-30 06:58   ` Re: BUG #16601: Restore Issue David G. Johnston <david.g.johnston@gmail.com>
  2020-08-30 08:46     ` Re: BUG #16601: Restore Issue Yash Raj <yashraj7960@gmail.com>
@ 2020-08-30 14:10       ` David G. Johnston <david.g.johnston@gmail.com>
  2020-08-31 20:27         ` Re: BUG #16601: Restore Issue David G. Johnston <david.g.johnston@gmail.com>
  0 siblings, 1 reply; 9+ messages in thread

From: David G. Johnston @ 2020-08-30 14:10 UTC (permalink / raw)
  To: Yash Raj <yashraj7960@gmail.com>; +Cc: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>

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.
>>
>>
>>
>>
>
> --
>
>
>
>
>
>
> *               Regards*
> *                 Yash*
>

^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: BUG #16601: Restore Issue
  2020-08-28 19:04 BUG #16601: Restore Issue PG Bug reporting form <noreply@postgresql.org>
  2020-08-28 19:45 ` Re: BUG #16601: Restore Issue David G. Johnston <david.g.johnston@gmail.com>
  2020-08-30 06:58   ` Re: BUG #16601: Restore Issue David G. Johnston <david.g.johnston@gmail.com>
  2020-08-30 08:46     ` Re: BUG #16601: Restore Issue Yash Raj <yashraj7960@gmail.com>
  2020-08-30 14:10       ` Re: BUG #16601: Restore Issue David G. Johnston <david.g.johnston@gmail.com>
@ 2020-08-31 20:27         ` David G. Johnston <david.g.johnston@gmail.com>
  2020-09-01 18:27           ` Re: BUG #16601: Restore Issue Yash Raj <yashraj7960@gmail.com>
  0 siblings, 1 reply; 9+ messages in thread

From: David G. Johnston @ 2020-08-31 20:27 UTC (permalink / raw)
  To: Yash Raj <yashraj7960@gmail.com>; +Cc: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>

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.
>>>>
>>>>
>>>>
>>>>
>>>
>>> --
>>>
>>>
>>>
>>>
>>>
>>>
>>> *               Regards*
>>> *                 Yash*
>>>
>>>
>>>
>>
>> --
>
>
>
>
>
>
> *               Regards*
> *                 Yash*
>

^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: BUG #16601: Restore Issue
  2020-08-28 19:04 BUG #16601: Restore Issue PG Bug reporting form <noreply@postgresql.org>
  2020-08-28 19:45 ` Re: BUG #16601: Restore Issue David G. Johnston <david.g.johnston@gmail.com>
  2020-08-30 06:58   ` Re: BUG #16601: Restore Issue David G. Johnston <david.g.johnston@gmail.com>
  2020-08-30 08:46     ` Re: BUG #16601: Restore Issue Yash Raj <yashraj7960@gmail.com>
  2020-08-30 14:10       ` Re: BUG #16601: Restore Issue David G. Johnston <david.g.johnston@gmail.com>
  2020-08-31 20:27         ` Re: BUG #16601: Restore Issue David G. Johnston <david.g.johnston@gmail.com>
@ 2020-09-01 18:27           ` Yash Raj <yashraj7960@gmail.com>
  0 siblings, 0 replies; 9+ messages in thread

From: Yash Raj @ 2020-09-01 18:27 UTC (permalink / raw)
  To: David G. Johnston <david.g.johnston@gmail.com>; +Cc: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>

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.
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>> --
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> *               Regards*
>>>> *                 Yash*
>>>>
>>>>
>>>>
>>>
>>> --
>>
>>
>>
>>
>>
>>
>> *               Regards*
>> *                 Yash*
>>
>>
>>
>
> --






*               Regards*
*                 Yash*

^ permalink  raw  reply  [nested|flat] 9+ messages in thread


end of thread, other threads:[~2020-09-01 18:27 UTC | newest]

Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-08-28 19:04 BUG #16601: Restore Issue PG Bug reporting form <noreply@postgresql.org>
2020-08-28 19:45 ` David G. Johnston <david.g.johnston@gmail.com>
2020-08-30 06:58   ` David G. Johnston <david.g.johnston@gmail.com>
2020-08-30 08:46     ` Yash Raj <yashraj7960@gmail.com>
2020-08-30 14:10       ` David G. Johnston <david.g.johnston@gmail.com>
2020-08-31 20:27         ` David G. Johnston <david.g.johnston@gmail.com>
2020-09-01 18:27           ` Yash Raj <yashraj7960@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox