/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

0 vote254 views1 answer
Dynamodb local how to delete table
Shell/Bash
4 votes229 views3 answers
Install magento 2 using composer
Shell/Bash
0 vote239 views1 answer
Raspberry shell get datetime now
Shell/Bash
-1 vote254 views3 answers
How to push newly created branch in git bash
Shell/Bash
2 votes220 views6 answers
Anydesk: error while loading shared libraries: libpangox-1.0.so.0: cannot open shared object file: no such file or directory
Shell/Bash
0 vote269 views2 answers
Apt update Release is not signed
Shell/Bash
2 votes246 views1 answer
Adb failed to connect to '192.168.0.9:5555': Connection refused
Shell/Bash
4 votes230 views1 answer
Git remove las remotet commit
Shell/Bash
2 votes226 views1 answer
How to open files from git bash
Shell/Bash
3 votes209 views1 answer
How to sign into github from terminal
Shell/Bash

Share