updated the postgis from 2.5.4 to 3.3.2, the new updated postgis will be supported from 7X. As part of that following are the changes made in this pr:

- Added upstream source of postgis 3.3.2
- Updated gdal and proj
- Updated readme, lib readme
- done clean up of 2.5 or older version-related stuff,
  as the main branch will be having source related to postgis 3.3
- Updated version info

Co-authored-by: Orhan Kislal <[email protected]>

Failed test:  ./regress/core/tickets .. failed (diff expected obtained: /tmp/pgis_reg/test_82_diff)
with following reason
NOTICE:  One or more columns in the following table(s) do not have statistics: utm_dots
Fix: as the notice was because analyze <tablename> was not performed for
the test and minimum log level was set to notice causing this diff.
Added analyze utm_dots; instruction to the test query.

Issue:
if the ibtiff is not available still the postgis gppkg is getting
installed.  this causing the issue while creating a postgis extension
for database.

Fix: added depedency check in .spec file as part of preinstall script.

In gppkg there is plan to add dependency check as part of host
requirement, but that yet to implement. so for now adding check in spec
file to error out if libtiff is not available.

This commit adds a plpython function to generate the state-wise scripts
for tiger geocoder.

Tiger installer creates plpython which was necessary for the tests but
it actually breaks the installation if the db already has the language.
Instead we add the language loading work to the pg_regress.

We also disable orca for one the raster tests since it was giving
sporadic errors.

Backport of postgis/postgis@a3df807

Includes const correctness fixes postgis/postgis@8d0df58

This commit updates the README  and postgis package docs version and
description:

This commit includes the following changes:
1. README.md:
   - Replaced all instances of "Greenplum" with "Cloudberry" to reflect
     the new naming convention.
2. postgis/package/gppkg_spec.yml.in:
   - update the version of hashdata and cloudberry database and the
     description of postgis.
3. postgis/package/gppkg_spec_v2.yml.in:
   - update the version of hashdata and cloudberry database and the
     description of postgis.
4. postgis/package/postgis.spec:
  - update the summary and description of postgis.

 Related to Issue#id <cloudberry-contrib#2>