2

I have POSTGIS="2.4.3 r16312" on my linux server and I need to upgrade it to POSTGIS="2.4.4 r16526" or any newer version. I use the following:

ALTER EXTENSION postgis UPDATE;

but it gives me the apparante message:

version "2.4.3" of extension "postgis" is already installed

Would you plesae let me know if how to upgrade the PostGIS version?

Improve this question
3
  • How did you install the new PostGIS version?
    – CL.
    Commented Apr 30, 2019 at 11:16
  • $ sudo apt-get install postgis
    – Nabat Farsi
    Commented May 2, 2019 at 4:13
  • Which version did you install (what is the output of apt list postgis)?
    – CL.
    Commented May 2, 2019 at 6:22

1 Answer 1

Reset to default
1

You need to also include the version number using the TO 'x.x.x'

Where 'x.x.x' is the new version. Note the ' (single quotes) are required as it's a string being used.

From the PostgreSQL ALTER EXTENSION documentation:

ALTER EXTENSION extension_name UPDATE [ TO new_version ]

Improve this answer
2
  • 1
    it gives a new error that ** extension "postgis" has no update path from version "2.4.3" to version "2.4.4"**. I tried to "2.4.4 r16526" and same message. I know this version exists because that is what I have installed on windows.
    – Nabat Farsi
    Commented Apr 25, 2019 at 22:44
  • its having trouble finding the update script. there is a SQL file that that command calls for one postgis version to another.
    – SaultDon
    Commented Apr 26, 2019 at 2:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.