How to generate a Postgresql Dump from a Docker container?

postgresql docker containers
Cesar Augusto Nogueira picture Cesar Augusto Nogueira · May 11, 2015 · Viewed 38.9k times · Source

I would like to have a way to enter into the Postgresql container and get a data dump from it.

Answer

Cesar Augusto Nogueira picture Cesar Augusto Nogueira · May 11, 2015

Use the following command from a UNIX terminal:

docker exec <container_name> pg_dump <schema_name> > backup

The following command will dump only inserts from all tables:

docker exec <container_name> pg_dump --column-inserts --data-only  <schema_name> > inserts.sql

Related questions

How to access Postgres database within docker-compose

I'm pretty new to Postgres and Docker, but I am building a webapp with Django that runs inside a docker with a postgresql database. I am trying to view my Postgres database via the command prompt or pgweb. Unfortunately, I …

Read More
How to create User/Database in script for Docker Postgres

I have been trying to set up a container for a development postgres instance by creating a custom user & database. I am using the official postgres docker image. In the documentation it instructs you to insert a bash script …

Read More
Connecting to Postgresql in a docker container from outside

I have Postgresql on a server in a docker container. How can I connect to it from the outside, that is, from my local computer? What setting should I apply to allow that?

Read More