Fresh Ubuntu 14.04 hangs on Create with Hyphens about dokku-postgres HOT 9 CLOSED

huh, seems related to the hyphen. jaime_johnson_staging works fine, as does staging

from dokku-postgres.

What is the output of docker ps -a ?

from dokku-postgres.

Container is created:

CONTAINER ID        IMAGE                                COMMAND                CREATED             STATUS                    PORTS               NAMES
56c808f753a4        postgres:9.5                         "/docker-entrypoint.   38 seconds ago      Up 38 seconds             5432/tcp            dokku.postgres.database-hyphen

Running the command with dokku trace on shows it looping infinitely with:

+ PGPASSWORD=NWVkNzc4ZmVhYmMw
+ psql --quiet -h 172.17.0.92 -p 5432 -U postgres --command 'CREATE DATABASE database-hyphen;'
+ continue
+ true

from dokku-postgres.

Interesting. Looks like postgres hates databases with hyphens in it - and thats how we figure out what the database name should be:

https://stackoverflow.com/questions/10216784/what-is-a-valid-postgresql-database-name

What happens if you add double-quotes around the database name?

from dokku-postgres.

Same problem, seems to strip the quotes:

Loop:

+ PGPASSWORD=MWU5NjNiMDNjM2E4
+ psql --quiet -h 172.17.0.93 -p 5432 -U postgres --command 'CREATE DATABASE database-hyphen-with-quotes;'
+ continue
+ true

from dokku-postgres.

We may need a function to normalize the DB name (like it’s done in https://github.com/Flink/dokku-psql-single-container/blob/master/functions#L36 for example)

from dokku-postgres.

Thats what I'm thinking. We should also make this standard across all datastores (Where a database is "required").

from dokku-postgres.

If someone wants to come up with a PR proof of concept for this repo, I can port everywhere else :)

from dokku-postgres.

👍 its a little over my head at the moment

from dokku-postgres.