PostGIS Extension? about dokku-postgres HOT 17 CLOSED

@pythdasch, Use the docker command to pull the image you want:

(sudo) docker pull mdillon/postgis:latest

Then just set your env vars:

export POSTGRES_IMAGE="mdillon/postgis" 
export POSTGRES_IMAGE_VERSION="latest"

Then you just use the plugin to create a new database.

from dokku-postgres.

Because I just spent some time on this, I had to run:

dokku postgres:connect DB

and

CREATE EXTENSION postgis;

to get this to work.

from dokku-postgres.

DAMN it !!! I did it !!! Thanks a lot @sethdeckard :)

from dokku-postgres.

If the postgis image is compatible with the official one, then yeah it should work.
As explained in the README, you just have to define those env var:

export POSTGRES_IMAGE="postgres"
export POSTGRES_IMAGE_VERSION="9.4.4"

from dokku-postgres.

I'm very interested about this issue because I'm block with postgis. I tried the other plugins but they aren't fully compatible with the new dokku version... how could I resolve this ?

from dokku-postgres.

@pythdasch, I was able to get this working using the postgis Docker image @willcodeforfoo mentions above, just install the Docker image you want (here's what I have currently):

mdillon/postgis latest f277f6afdf67 2 weeks ago 431.5 MB
mdillon/postgis 9.4 709cb883439d 2 weeks ago 431.5 MB

Then just change the two ENV vars mentioned in the docs to point to an installed PostGIS image and you should be good to use the plugin to create new database containers.

from dokku-postgres.

Ok I'll try then, thx for the tips :)

from dokku-postgres.

@sethdeckard Thanks! Dumb question, where should I set those ENV vars?

from dokku-postgres.

Good question @willcodeforfoo. @sethdeckard what is the workflow to achieve what you did ?
I guess you installed postgres plugin, after you did the small tutorial about installing postgis tutorial and putted the env, where ? Also, did you create a database in dokku with the plugin like dokku postgres:create foo or by docker ?

from dokku-postgres.

@willcodeforfoo, You can set them per session or permanently via /etc/environment.

To elaborate /etc/environment would make them available to all users, I wasn't sure if the dokku user needs them as well, perhaps not.

from dokku-postgres.

Thx @sethdeckard I did all of this in my dokku (I'm with digitalocean) but I'm stuck after :
Must I create a database with postgres:create or not? because when I try to link my app to mdillon/postgis image it says that the service doesn't exist. thx for your patience

from dokku-postgres.

Yes, you must create your database with the plugin (postgres:create), the ENV vars are used by it to know which postgres image to use when creating your container.

from dokku-postgres.

You can't list a service that isn't created ;)

from dokku-postgres.

Hi I'm having issue with this trick because of : Error parsing reference: "mdillon/postgis" :9.5.2" is not a valid repository/tag.

from dokku-postgres.

I trried also latest but fails also :(

from dokku-postgres.

it's ok I did it !

from dokku-postgres.

FYI postgis has an official docker image you can use now: postgis/postgis

from dokku-postgres.