Postgres Pro
Downloads
Home   >   mailing lists

Re: Errors when restoring backup created by pg_dumpall - Mailing list pgsql-general

From David G. Johnston
Subject Re: Errors when restoring backup created by pg_dumpall
Date
Msg-id CAKFQuwaXsgZncO10khobrdC=_NLxBWQX4XQEuVVCfouqqrnLHA@mail.gmail.com
Whole thread Raw
In response to Re: Errors when restoring backup created by pg_dumpall  (Ron Johnson <ronljohnsonjr@gmail.com>)
Responses Re: Errors when restoring backup created by pg_dumpall
List pgsql-general
Tree view
On Thu, Dec 5, 2024 at 4:04 PM Ron Johnson <ronljohnsonjr@gmail.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.

pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Errors when restoring backup created by pg_dumpall
Next
From: Erik Wienhold
Date:
Subject: Re: Best Practices for Managing Schema Changes Dynamically with libpq