/Shell/Bash/Pg_restore docker

Pg_restore docker

Pg_restore, pg_dump

pg_restore --verbose --clean --no-acl --no-owner --host=localhost --dbname=db_name --username=username latest.dump

1

Source: stackoverflow.com

Pgrestore schema backup to a container

docker exec -i pg_container_name psql --username pg_username [--password pg_password] database_name < /path/on/your/machine/dump.sql

1

Source: davejansen.com

Pg_restore docker

docker-compose exec -T "${DB_CONTAINER}"  pg_restore -C --clean --no-acl --no-owner -U "${DB_USER}" -d "${DB_NAME}" < "${LOCAL_DUMP_PATH}"

0

Source: stackoverflow.com

Similar codes

1 vote349 views2 answers
Git branch from commit
Shell/Bash
12 votes321 views2 answers
Intellij ultimate install ubuntu
Shell/Bash
2 votes313 views1 answer
Bash float division
Shell/Bash
0 vote340 views1 answer
Git see remote changes before pull
Shell/Bash
0 vote330 views1 answer
Install python module ImageTk
Shell/Bash
0 vote328 views1 answer
How to SSH on a port other than 22
Shell/Bash
0 vote367 views2 answers
Cordova install plugin at branch
Shell/Bash
0 vote349 views1 answer
Create multiple copies in linux of file
Shell/Bash
0 vote312 views2 answers
OpenSSL SSL_connect: SSL_ERROR_SYSCALL in connection to github.com:443
Shell/Bash
2 votes283 views1 answer
Bash how to download files from a list of links
Shell/Bash

Share