Reset DB

[fgblomqvist]

Heroku has the command pg:reset that just resets a db. This is useful when e.g. cloning a DB from production to staging regularly (and automatically).

dokku postgres:reset staging-db
dokku postgres:export db | dokku postgres:import staging-db

[pynixwang]

maybe
dokku postgres:exec 'drop schema public cascade; create schema public;'

exec also can execute other command.

[fgblomqvist]

Right, the actual command required to do it right now is not very complicated. In the end, pg:reset could certainly just execute a command similar to that. I still think having the pg:reset command would just simplify things.

[pynixwang]

@fgblomqvist but exec command is more useful, can reset db, can run a db init script, or other awesome thing.

[fgblomqvist]

@pynixwang

Of course, but why do we even have this whole addon then? PSQL is much more useful, you can achieve every single thing with it.

You're missing my point completely.

[josegonzalez]

@fgblomqvist Would you be willing to come up with a PR for this functionality?

[fgblomqvist]

I haven't been using Dokku for a few months and currently don't have any environment set up for testing something like this. If this still hasn't been created next time I set one up I can definitely give it a try, but yeah, not now.

(I do remember taking a look at it back in May but I think I concluded that I needed to get a bit more familiar with the code base before I could do anything)

[pynixwang]

@fgblomqvist yes PSQL is more useful, but you must enter an interactive environment. and you can not run some command quietly.

[fgblomqvist]

@pynixwang Wrong. psql -c "select * from my_table". The output can be redirected however you like it, or if you want to not see it at all you can just redirect it accordingly.

[pynixwang]

@fgblomqvist dokku postgresql has no psql command. maybe heroku has it.

[josegonzalez]

Thats actually not true. We use it here.

For the purposes of this issue, I am on-board with the feature. If someone wants to implement it, great. Otherwise, I'd appreciate keeping the chatter to a minimum, I get a ton of GH notifications and its hard to keep up sometimes :(

[cristianszwarc]

manual alternative

    dokku postgres:create some_amazing_db
    docker exec "dokku.postgres.some_amazing_db" su - postgres -c "dropdb some_amazing_db"
    docker exec "dokku.postgres.some_amazing_db" su - postgres -c "createdb -E utf8  some_amazing_db"

[josegonzalez]

Closing as there is an in-progress PR for this.