public inbox for [email protected]help / color / mirror / Atom feed
Re: 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]> 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-02 23:21 PopeRigby <[email protected]> parent: 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-03 01:17 Tom Lane <[email protected]> parent: 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-04 05:13 PopeRigby <[email protected]> parent: Tom Lane <[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