Postgis Setup

rehatkathuria
HOBBY

7 months ago

When trying to install PostGIS on Postgres, do I need to chain my database URL references like so?

+--------------------------------------------------+

| Halfway

| XXXXXXXXXXXX.com

| (Crashed 2 minutes ago)

+-------------------------------+-------------------+

|

v

+--------------------------------------------------+

| PostGIS

| 5 minutes ago via Docker Image

| time-volume

+-------------------------------+-------------------+

|

v

+--------------------------------------------------+

| Postgres

| 4 weeks ago via Docker Image (debt-volume) |

+--------------------------------------------------+

Or do I simply reference the PostGIS extension? Is the PostGIS template a fully fledged database with the extension enabled? A migration of mine is failing which starts with the following:

```
CREATE EXTENSION IF NOT EXISTS postgis;

```

Solved

3 Replies

7 months ago

Hello,

We do not support installing postgis on existing databases, you would need to deploy the PostGIS template into your project and use that database instead.

Best,

Brody


Status changed to Awaiting User Response Railway 7 months ago


rehatkathuria
HOBBY

7 months ago

Would the team consider renaming the template to "Postgres + PostGIS"? I think that rename would be better DX. Also, I'm seeing this error message despite the template instantiating with these variables. The database is up and running as expected. Is this error safe to ignore?

Attachments


Status changed to Awaiting Railway Response Railway 7 months ago


7 months ago

Yep that error won't cause any issue to PostGIS itself.


Status changed to Awaiting User Response Railway 7 months ago


Railway
BOT

a month ago

This thread has been marked as solved automatically due to a lack of recent activity. Please re-open this thread or create a new one if you require further assistance. Thank you!

Status changed to Solved Railway about 1 month ago