/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

1 vote270 views1 answer
Awk skip first line
Shell/Bash
0 vote243 views1 answer
Mac m1 Error running pod install
Shell/Bash
1 vote247 views2 answers
Git see all tracked files
Shell/Bash
-1 vote267 views1 answer
Psneuter download
Shell/Bash
12 votes272 views1 answer
Dir sort by
Shell/Bash
22 votes275 views2 answers
Apt install package version
Shell/Bash
0 vote263 views1 answer
Centos 7 ius-release.rpm
Shell/Bash
122 votes272 views6 answers
How to uninstall npm package
Shell/Bash
1 vote278 views1 answer
Ip config ubuntu
Shell/Bash
0 vote293 views1 answer
Git diff no context
Shell/Bash

Share