/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 vote145 views1 answer
Dd mac status
Shell/Bash
0 vote150 views1 answer
Install rollup locally
Shell/Bash
11 votes145 views3 answers
Move all files from one directory to another
Shell/Bash
3 votes150 views2 answers
Uninstall node using n
Shell/Bash
0 vote151 views2 answers
Install coreutils
Shell/Bash
1 vote129 views1 answer
Git cherry pick resolve conflict
Shell/Bash
131 votes203 views6 answers
Git undo last commit
Shell/Bash
0 vote151 views1 answer
Grep pattern options
Shell/Bash
0 vote195 views1 answer
Ubuntu 18.04 default display manager
Shell/Bash
3 votes122 views1 answer
Delete floder linux
Shell/Bash

Share