How can I pass --data-only --table when doing a dump?

[sglebs]

How can I perform a dump as described in https://feeding.cloud.geek.nz/posts/restoring-single-table-from-postgres/ , passing --data-only and --table ?

I would like to pass these parameters on dump and, in some cases, on restore as well (when restoring from full dumps).

If you can provide an example, that would be great. Thanks!

[sglebs]

FOr the record, this did not work for me:

dokku psql:dump softdispdjango-dev --data-only --table=dashboard_system --table=dashboard_systemdependency  > softdispdjango-dev.dump

[Flink]

Well you can’t, the dump and restore commands are done like it works on heroku. What you can do is to use directly pg_dump and pg_restore in the container via docker exec.
You could do something like docker exec -i psql-single-container pg_dump --data-only … > database.dump I think

[sglebs]

dokku 0.4.5 via vagrant installs in such a way that docker commends are failing.

vagrant@dokku-vagrant:~$ docker ps
Cannot connect to the Docker daemon. Is the docker daemon running on this host?

Doing some RTFM to figure things out.

[Flink]

You have to use sudo to use docker :)

[sglebs]

d'oh of course!

[sglebs]

For the record, I am only trying to do this because of the problems I had in ticket #22 with a regular, full dump&restore.