POSTGIS EXTENSION NOT AVAILABLE FOR POSTGRESQL

sunmadebabafemi
TRIAL

8 months ago

i have a database i just created.

i am trying to migrate to this new db from an old one hosted on render.

unfortunately my migration file keeps breaking with this error:

driverError: error: type "geography" does not exist

{

length: 97,

severity: 'ERROR',

code: '42704',

detail: undefined,

hint: undefined,

position: '882',

internalPosition: undefined,

internalQuery: undefined,

where: undefined,

schema: undefined,

table: undefined,

column: undefined,

dataType: undefined,

constraint: undefined,

file: 'parse_type.c',

line: '270',

routine: 'typenameType'

},

this is as a result of the postgis extension not installed on the postgres db directly from the server. please help me resolve this as we are about to go live in a few days

1 Replies

8 months ago

Hello,

You would need to use the PostGIS template if you need postgis -

https://railway.app/template/postgis


POSTGIS EXTENSION NOT AVAILABLE FOR POSTGRESQL - Railway Help Station