Determining postgis version from pg_dump

[Regina Obe]

I don’t think so.  As I recall when you do a pg_dump, it just stores the 

 

CREATE EXTENSION … line without a VERSION so you can’t tell.

 

I could be mistaken though.

 

From: B H <hemantbist at gmail.com> 
Sent: Friday, March 22, 2024 2:50 PM
To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
Subject: Determining postgis version from pg_dump

 

Hi, 

I have a year old snapshot of postgresql that had an older version of postgis installed at that time.

Is it possible for me to figure out from the dump what version of postgis was installed at that time?

#command used to dump the db.

pg_dump  -Fc -b -v -f <filename> <dbname>

 

I am hoping it is stored in some data/function that pg_dump .

I know it had 2.4.8 to 2.5.9 version (I just don't know which one).

Best,

HB

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20240322/9587a235/attachment.htm>