/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 vote317 views1 answer
Important linux command
Shell/Bash
3 votes304 views2 answers
Git clone with different name
Shell/Bash
1 vote281 views1 answer
Change wp permission ubuntu
Shell/Bash
12 votes316 views1 answer
How to create a vm in anaconda
Shell/Bash
2 votes289 views2 answers
Change user of a directory in linux
Shell/Bash
23 votes290 views3 answers
Brew command not found
Shell/Bash
2 votes292 views1 answer
Ubuntu restart sound
Shell/Bash
5 votes299 views2 answers
Settings not showing in ubuntu
Shell/Bash
0 vote295 views1 answer
Rvm set default
Shell/Bash
75 votes298 views4 answers
Upload new repo to git
Shell/Bash

Share