/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 vote221 views1 answer
Chocolatey terraform install
Shell/Bash
-1 vote198 views2 answers
Aws extend volume ubuntu
Shell/Bash
2 votes231 views1 answer
Archlinux install chrome
Shell/Bash
4 votes209 views1 answer
Linux find directores
Shell/Bash
0 vote174 views1 answer
Linux Mint reset xfce-panel
Shell/Bash
0 vote234 views0 answer
Shell/Bash
42 votes247 views5 answers
Homebrew
Shell/Bash
0 vote187 views1 answer
Vim command to select all text in file
Shell/Bash
-2 votes181 views2 answers
Linux print system info
Shell/Bash
0 vote209 views1 answer
\r' end of bash file
Shell/Bash

Share