/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 vote152 views1 answer
How do you run a lisp file with sbcl
Shell/Bash
0 vote146 views1 answer
Start and Enable Apache
Shell/Bash
0 vote143 views1 answer
Pipeline command in linux
Shell/Bash
0 vote151 views1 answer
Bash float operations
Shell/Bash
0 vote151 views1 answer
How to make directory in ubantu
Shell/Bash
0 vote153 views2 answers
How to run command in background bash linux
Shell/Bash
0 vote111 views1 answer
Tell cmake where to find the compiler by setting either the environment variable "cxx" or the cmake cache entry cmake_cxx_compiler to the full path to the compiler, or to the compiler name if it is in the path.
Shell/Bash
-2 votes165 views2 answers
Github how to add ssh key
Shell/Bash
0 vote161 views1 answer
Start rc.local manually
Shell/Bash
0 vote150 views1 answer
Install gcmcore debian 10
Shell/Bash

Share