Re: Postgresql Upgrade

On Tue, Aug 27, 2024 at 6:31 AM SOzcn <selahattinozcnma(at)gmail(dot)com> wrote:

> Hello,
>
> There is few cluster which is using fk server and postgis.
>
> For the upgrade this servers, I need the drop extension and then re-create
> them.
> Just in case if I do that with pg_dump, am i still have to re-create
> postgis and fk servers?
>

Out of curiosity, what's "fk"? It can't be "FOREIGN KEY", can it?

> I didin't want waste time before the do that so I need your advice.
>

I doubt it, since pg_dump generates *all* of CREATE (and ALTER) statements
required for a database, and pg_restore then runs them.

Thus, if (new) postgis and fk packages are installed on the new server,
pg_restore will CREATE EXTENSION with the new version of postgis.

Of course, there might be some hard-coded extension version numbers in the
dump. Run "pg_dump --schema-only $DB >> ${DB}.sql" and then scan it for
postgis references to "see what you see". Maybe even run that no-data
script on the new server, and see what postgis and fk versions you get.

> Is there anyone have experience with this?
>

--
Death to America, and butter sauce.
Iraq lobster!