[postgis-users] How to migrate to new server when PostGIS generations differ

[Christophe Pettus]

> On Nov 12, 2023, at 08:51, Troels Arvin <troels at arvin.dk> wrote:
> 
> OK, that sounds like I may need to plan with more downtime. But then again: If I can verify, that no code is using the aggregates/types which pg_restore complains about (such as the public.accum aggregate), shouldn't it be OK to pg_dump->pg_restore directly to the newer installation?

You can try it and see, although there are a sufficient number of other upgrade steps between those two PostGIS versions that I would advise the more methodical approach.