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 -