On 2024-03-22 20:00 +0100, Regina Obe wrote:
> 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.
No, you're right. Omitting the version is intentional. From the
pg_dump
The only reason I can think why QGIS and DBeaver would show something different
is how they are projecting.
I’m guessing they are both projecting to Web Mercator or some such thing to
overlay your geometry on the map, and their assumptions about SRID 28992 are
different.
I’d try
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
Sent: Friday, March 22, 2024 2:50 PM
To: PostGIS Users Discussion
Subject: Determining postgis version from
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
I am hoping it is stored in some