public inbox for [email protected]
help / color / mirror / Atom feedRe: Errors when restoring backup created by pg_dumpall
4+ messages / 2 participants
[nested] [flat]
* Re: Errors when restoring backup created by pg_dumpall
@ 2024-12-01 20:15 Tom Lane <[email protected]>
2024-12-02 23:21 ` Re: Errors when restoring backup created by pg_dumpall PopeRigby <[email protected]>
0 siblings, 1 reply; 4+ messages in thread
From: Tom Lane @ 2024-12-01 20:15 UTC (permalink / raw)
To: PopeRigby <[email protected]>; +Cc: David G. Johnston <[email protected]>; Adrian Klaver <[email protected]>; pgsql-general
PopeRigby <[email protected]> writes:
> I've applied the following patch to postgres:
> https://www.postgresql.org/message-id/attachment/122092/0002-earthdistance-sql-functions.patch
Cool. You did actually install the new scripts into your target
installation, right?
> I'm still getting this error:
> psql:all.sql:4102: ERROR: type "earth" does not exist
> LINE 1: ...ians($1))*sin(radians($2))),earth()*sin(radians($1)))::earth
Hmmm ... a pg_dumpall output script shouldn't really contain that
function body directly; it should just say "CREATE EXTENSION
earthdistance". Is it possible that this database is so old that
it contains a pre-extension (pre-9.1) version of earthdistance?
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Errors when restoring backup created by pg_dumpall
2024-12-01 20:15 Re: Errors when restoring backup created by pg_dumpall Tom Lane <[email protected]>
@ 2024-12-02 23:21 ` PopeRigby <[email protected]>
2024-12-03 01:17 ` Re: Errors when restoring backup created by pg_dumpall Tom Lane <[email protected]>
0 siblings, 1 reply; 4+ messages in thread
From: PopeRigby @ 2024-12-02 23:21 UTC (permalink / raw)
To: Tom Lane <[email protected]>; +Cc: David G. Johnston <[email protected]>; Adrian Klaver <[email protected]>; pgsql-general
On 12/1/24 12:15, Tom Lane wrote:
> Cool. You did actually install the new scripts into your target
> installation, right?
Oh, is applying the patch and rebuilding PostgreSQL not enough?
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Errors when restoring backup created by pg_dumpall
2024-12-01 20:15 Re: Errors when restoring backup created by pg_dumpall Tom Lane <[email protected]>
2024-12-02 23:21 ` Re: Errors when restoring backup created by pg_dumpall PopeRigby <[email protected]>
@ 2024-12-03 01:17 ` Tom Lane <[email protected]>
2024-12-04 05:13 ` Re: Errors when restoring backup created by pg_dumpall PopeRigby <[email protected]>
0 siblings, 1 reply; 4+ messages in thread
From: Tom Lane @ 2024-12-03 01:17 UTC (permalink / raw)
To: PopeRigby <[email protected]>; +Cc: David G. Johnston <[email protected]>; Adrian Klaver <[email protected]>; pgsql-general
PopeRigby <[email protected]> writes:
> On 12/1/24 12:15, Tom Lane wrote:
>> Cool. You did actually install the new scripts into your target
>> installation, right?
> Oh, is applying the patch and rebuilding PostgreSQL not enough?
Not unless you did "make install" in the contrib/earthdistance
directory (or something wider-scope that would invoke that).
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Errors when restoring backup created by pg_dumpall
2024-12-01 20:15 Re: Errors when restoring backup created by pg_dumpall Tom Lane <[email protected]>
2024-12-02 23:21 ` Re: Errors when restoring backup created by pg_dumpall PopeRigby <[email protected]>
2024-12-03 01:17 ` Re: Errors when restoring backup created by pg_dumpall Tom Lane <[email protected]>
@ 2024-12-04 05:13 ` PopeRigby <[email protected]>
0 siblings, 0 replies; 4+ messages in thread
From: PopeRigby @ 2024-12-04 05:13 UTC (permalink / raw)
To: Tom Lane <[email protected]>; +Cc: David G. Johnston <[email protected]>; Adrian Klaver <[email protected]>; pgsql-general
On 12/2/24 17:17, Tom Lane wrote:
> PopeRigby <[email protected]> writes:
>> On 12/1/24 12:15, Tom Lane wrote:
>>> Cool. You did actually install the new scripts into your target
>>> installation, right?
>> Oh, is applying the patch and rebuilding PostgreSQL not enough?
> Not unless you did "make install" in the contrib/earthdistance
> directory (or something wider-scope that would invoke that).
>
> regards, tom lane
Well, I did actually compile PostgreSQL after applying the patch.
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2024-12-04 05:13 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-12-01 20:15 Re: Errors when restoring backup created by pg_dumpall Tom Lane <[email protected]>
2024-12-02 23:21 ` PopeRigby <[email protected]>
2024-12-03 01:17 ` Tom Lane <[email protected]>
2024-12-04 05:13 ` PopeRigby <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox