Re: Errors when restoring backup created by pg_dumpall

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Errors when restoring backup created by pg_dumpall
Date: 2024-12-05 23:23:49
Message-ID: CAKFQuwaXsgZncO10khobrdC=_NLxBWQX4XQEuVVCfouqqrnLHA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Dec 5, 2024 at 4:04 PM Ron Johnson <ronljohnsonjr(at)gmail(dot)com> wrote:

> Another alternative is to open the .sql file in Notepad++, then add
> "public." before all the unqualified "earth" and "ll_to_earth" references.
>

And as discussed there are none in that file because those references are
within an extension's objects and only create extension appears in the file.

David J.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Erik Wienhold 2024-12-06 02:06:03 Re: Best Practices for Managing Schema Changes Dynamically with libpq
Previous Message Ron Johnson 2024-12-05 23:04:31 Re: Errors when restoring backup created by pg_dumpall