fazer backup postgresql no docker

netocazuza
(usa Ubuntu)

Enviado em 20/10/2018 - 21:03h

sudo docker-compose exec postgres_95 bash 

pg_dump -v -F p -h postgres -U postgres > backup20102018.sql 

pg_dump: [archiver (db)] connection to database "postgres" failed: could not translate host name "postgres" to address: Name or service not known 

su - postgres 

pg_dump -v -F p -h postgres -U postgres > backup20102018.sql 

-su: 1: cannot create backup20102018.sql: Permission denied 

removido
(usa Nenhuma)

Enviado em 23/10/2018 - 00:00h

sudo docker-compose exec postgres_95 bash 

pg_dump -v -F p -h postgres -U postgres > backup20102018.sql 

pg_dump: [archiver (db)] connection to database "postgres" failed: could not translate host name "postgres" to address: Name or service not known 

su - postgres 

pg_dump -v -F p -h postgres -U postgres > backup20102018.sql 

-su: 1: cannot create backup20102018.sql: Permission denied 

netocazuza
(usa Ubuntu)

Enviado em 09/11/2018 - 12:53h

pc2@pc2-POS-AG31AP:~/i-educar$ sudo cat /home/pc2/Downloads/backupIeducar09112018.backup | docker-compose exec -i postgres_95 psql -U postgres

Execute a command in a running container



Usage: exec [options] [-e KEY=VAL...] SERVICE COMMAND [ARGS...]



Options:

    -d, --detach      Detached mode: Run command in the background.

    --privileged      Give extended privileges to the process.

    -u, --user USER   Run the command as this user.

    -T                Disable pseudo-tty allocation. By default `docker-compose exec`

                      allocates a TTY.

    --index=index     index of the container if there are multiple

                      instances of a service [default: 1]

    -e, --env KEY=VAL Set environment variables (can be used multiple times,

                      not supported in API < 1.25)

    -w, --workdir DIR Path to workdir directory for this command.