Re: srtext 2048 length limit

On Thu, 22 May 2025 at 02:59, Paul Ramsey <[email protected]> wrote:
> > On May 21, 2025, at 7:43 AM, Regina Obe <[email protected]> wrote:
> > The general advice is if you want to make changes, you should make it in your proj.db database since that is the first source of truth for PostGIS these days.
> Frankly, even if you wanted to change an existing srs, the smart thing to do would be to add a new line and a new srid number to spatial_ref_sys, because there’s nothing stopping proj.db from being over-written by software upgrades etc.

Since PROJ 8.1, custom projections should be added to an auxiliary
database, rather than added to proj.db. The location of this would
normally be defined with PROJ_AUX_DB
https://proj.org/en/stable/usage/environmentvars.html#envvar-PROJ_AUX_DB

See the example here on how to create and modify an auxiliary
database: proj.org/en/stable/apps/projinfo.html#projinfo-aux-db-example