/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 vote154 views1 answer
Docfetcher ubuntu
Shell/Bash
1 vote126 views1 answer
The file is not digitally signed powershell
Shell/Bash
0 vote120 views1 answer
How to add the permission in the lampp in ubuntu
Shell/Bash
1 vote150 views1 answer
How to unstage a commit
Shell/Bash
15 votes143 views6 answers
Install wine ubuntu
Shell/Bash
0 vote116 views1 answer
Check your PC's SSH Key
Shell/Bash
0 vote134 views1 answer
Installing ipython-sql in Jupyter
Shell/Bash
1 vote135 views1 answer
Jupyter labs install conda windows
Shell/Bash
0 vote161 views1 answer
Skipping acquire of configured file 'main/binary-i386/Packages' as repository 'https://apt.repos.neuron.amazonaws.com bionic InRelease' doesn't support architecture 'i386'
Shell/Bash
0 vote78 views1 answer
Stacer for ubuntu
Shell/Bash

Share