Postgres Pro
Downloads
Home   >   mailing lists

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

From Ron Johnson
Subject Re: Errors when restoring backup created by pg_dumpall
Date
Msg-id CANzqJaA1VV6gzoBTLAwUcm5cOzNPhtKUVfvxpa66BttP1EgPqg@mail.gmail.com
Whole thread Raw
In response to Re: Errors when restoring backup created by pg_dumpall  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Errors when restoring backup created by pg_dumpall
Re: Errors when restoring backup created by pg_dumpall
List pgsql-general
Tree view
On Thu, Dec 5, 2024 at 6:24 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
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.

Then why would changing search_path work? 

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

pgsql-general by date:

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