/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 vote189 views1 answer
Shell get unique lines
Shell/Bash
2 votes218 views2 answers
Data path ".builders['app-shell']" should have required property 'class'.
Shell/Bash
3 votes196 views1 answer
Ubuntu cli give full access to folder
Shell/Bash
31 votes210 views6 answers
Replace using sed
Shell/Bash
0 vote197 views2 answers
Pg_hba.conf location ubuntu 18.04
Shell/Bash
12 votes193 views1 answer
Linux check used space in folder
Shell/Bash
0 vote186 views4 answers
Outil de programmation socket sur ubuntu
Shell/Bash
1 vote195 views1 answer
Install epel amazon linux 2
Shell/Bash
3 votes228 views2 answers
How to enable remote desktop with cmd
Shell/Bash
1 vote225 views2 answers
Run script via ssh
Shell/Bash

Share