/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

8 votes272 views3 answers
Docker setup
Shell/Bash
0 vote271 views1 answer
Ignore .DS_store when uploading to s3 using shell
Shell/Bash
0 vote263 views1 answer
How to setup pre commit hook on my local
Shell/Bash
2 votes284 views3 answers
Download folder github
Shell/Bash
0 vote294 views1 answer
How to list all versions of pip in ubuntu using grep
Shell/Bash
3 votes299 views5 answers
How to install nodejs on manjaro
Shell/Bash
0 vote282 views3 answers
Ir para comit
Shell/Bash
0 vote267 views1 answer
Jq for xml
Shell/Bash
0 vote254 views1 answer
Cat /etc/passwd
Shell/Bash
90 votes279 views6 answers
Git remote show origin
Shell/Bash

Share