/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 vote187 views1 answer
Xclip does not work
Shell/Bash
0 vote280 views1 answer
Python3 GIVINGSTORM.py -n Windows-Upgrade -p b64 encoded payload -c amazon.com/c2/domain HTA Example
Shell/Bash
0 vote190 views1 answer
How to delete files in linxu terminal
Shell/Bash
-1 vote189 views1 answer
Reinstall all tables doctrine
Shell/Bash
22 votes196 views3 answers
Git pull from another branch
Shell/Bash
2 votes279 views1 answer
Make role ansible
Shell/Bash
0 vote195 views1 answer
Merge_otu_tables.py qiime
Shell/Bash
8 votes245 views2 answers
Ubuntu install brave
Shell/Bash
-3 votes187 views3 answers
Ubuntu install certbot
Shell/Bash
0 vote209 views4 answers
How to install pipenv
Shell/Bash

Share