/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

21 votes230 views6 answers
Restart nginx mac
Shell/Bash
20 votes187 views3 answers
How to run docker without sudo
Shell/Bash
0 vote164 views1 answer
How to enable tray icon on ubuntu 18.04
Shell/Bash
0 vote172 views1 answer
Conda install line_profiler
Shell/Bash
0 vote190 views1 answer
RequestsDependencyWarning chardet
Shell/Bash
0 vote156 views2 answers
Git push to current branch
Shell/Bash
1 vote183 views1 answer
Bash print fields that begin with string
Shell/Bash
9 votes189 views1 answer
Install vscode ubuntu 20.04 snap
Shell/Bash
0 vote161 views1 answer
Ubuntu path of saving screenshots
Shell/Bash
2 votes277 views3 answers
Conda install seaborn
Shell/Bash

Share