/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

7 votes180 views2 answers
Upgrade command magento 2
Shell/Bash
4 votes199 views2 answers
Pyinstaller no console
Shell/Bash
2 votes177 views1 answer
Env file firebase
Shell/Bash
3 votes199 views1 answer
Linux check cronjob log
Shell/Bash
0 vote191 views1 answer
ERR_NO_CERTIFICATES: Encountered adb error: NoCertificates. ionic
Shell/Bash
113 votes220 views6 answers
Remove last commit git
Shell/Bash
1 vote213 views1 answer
How to search all subfolders in linux for file
Shell/Bash
0 vote193 views1 answer
Create dummy file windows
Shell/Bash
0 vote203 views1 answer
Git stash changes to particular file
Shell/Bash
10 votes191 views1 answer
Check upstream
Shell/Bash

Share