/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 vote244 views1 answer
Install Apache FreeBSD
Shell/Bash
1 vote221 views1 answer
Install xampp on windows 10
Shell/Bash
0 vote205 views1 answer
INSTALL gedit on kali linux
Shell/Bash
0 vote210 views7 answers
Stop kill network connection using cmd line
Shell/Bash
1 vote205 views1 answer
Bad interpreter: /bin/python3^M: no such file or directory
Shell/Bash
0 vote222 views1 answer
Npm install smoothscroll-polyfill
Shell/Bash
0 vote205 views2 answers
Yaml
Shell/Bash
0 vote220 views1 answer
Sudo apt uninstall docker compose
Shell/Bash
0 vote205 views1 answer
Install tree in centos 7
Shell/Bash
1 vote208 views1 answer
Snapd unavailable solved
Shell/Bash

Share